'How to select row for an equal and different condition in qliksense

my aim is just to have a set analysis in qlik sense; I did this :

Sum({<[EstUnTotal_fg?] = {'NON'}, Direction <> {TOTAL}>}[CA par année])

My aim is to have row where

EstUnTotal_fg ="NON"  and Direction <> TOTAL for the CA par année

But the sign <> doesn't work. If I replace it per the sign = so it works.

How can I use the sign <> in my set analysis for my CA par année

Thanks for reading me

qliksenseset-analysis


Solution 1:[1]

To my knowledge, instead of using <> you can use = -. It is explained in this post by Henric_CronströM. So, your set analysis would look like this:

Sum({<[EstUnTotal_fg?] = {'NON'}, Direcations = - {Total}>} [Ca par année})

I hope it helped :)

Solution 2:[2]

Building on the first response, I have found the following PDF document to be helpful: Set-Analysis-syntaxes-examples

I believe there is a French (original?) version here: Sets-Analysis-syntaxes-exemples

Pay attention to page 8 (English version) where the author (also) distinguishes -= and = -.

These were sourced from the Qlik Community: Qlik Community

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Yago Biermann
Solution 2

Related Questions