Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Hemant,
Use the below expression:
Sum({$<[Current Sourcing Stage]={'6DNS'}, [Top Spend Indicator]= > } Ref Cost])
It will work.
Regards,
Nilesh Gangurde
Hi Hemant,
Use the below expression:
Sum({$<[Current Sourcing Stage]={'6DNS'}, [Top Spend Indicator]= > } Ref Cost])
It will work.
Regards,
Nilesh Gangurde
Your first example would do the trick.
Sum({$<[Current Sourcing Stage]={'6DNS'}>, [Top Spend Indicator]= > } Ref Cost])
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 ?
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
Just FYI - $ sign is for the current selections, but If you put 1 instead of $, you will ignore all selections.
Thanks again! That helps.