Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore selection in an expression (Set Analysis)

I would like to ignore selections (made in a list box) for expressions used in my pivot table.

I use the following expression in the table:

Sum({$<[Current Sourcing Stage]={'6DNS'}>} [Ref Cost])

I would like to ignore user selection of another field called [Top Spend Indicator]

Can you please confirm which of the below expressions ignores any selection in the field [Top Spend Indicator] :

1. Sum({$<[Current Sourcing Stage]={'6DNS'}>, [Top Spend Indicator]= > } Ref Cost])

OR

2. Sum({$<[Current Sourcing Stage]={'6DNS'}>} {<[Top Spend Indicator]= >}[Ref Cost])

or are they BOTH correct? Any comments on which expression to use if they are both correct.

Your help is much appreciated!

Thanks,

Hemanth.

1 Solution

Accepted Solutions
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi Hemant,

Use the below expression:

Sum({$<[Current Sourcing Stage]={'6DNS'}, [Top Spend Indicator]= > } Ref Cost])

It will work.

Regards,

Nilesh Gangurde


View solution in original post

6 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi Hemant,

Use the below expression:

Sum({$<[Current Sourcing Stage]={'6DNS'}, [Top Spend Indicator]= > } Ref Cost])

It will work.

Regards,

Nilesh Gangurde


Not applicable
Author

Your first example would do the trick.
Sum({$<[Current Sourcing Stage]={'6DNS'}>, [Top Spend Indicator]= > } Ref Cost])

Not applicable
Author

Thanks a lot Nilesh and Max.

Can you please let me know if the '$' sign has any significance in the below expression:

=Sum({$<[Current Sourcing Stage]={'6DNS'},[Top Spend Indicator]= >} [Ref Cost])

I get the same result when I remove the '$' sign from the above expression:

=Sum({<[Current Sourcing Stage]={'6DNS'},[Top Spend Indicator]= >} [Ref Cost])

I would like to understand the implications of removing the $ sign if any ?

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi Hemant,

$ sign is used for the current selctions. it means your results will be change according to the selections you made in the qvw file.

Qlikview bydefault takes the current selection. hence its giving the same results when you removing the $ sign.

the conclusion is you will get the same results whether you are keeping $ sign or removing it.

Regards,

Nilesh Gangurde

Not applicable
Author

Just FYI -  $ sign is for the current selections, but If you put 1 instead of $, you will ignore all selections.

Not applicable
Author

Thanks again! That helps.