topic Ignore selection in an expression (Set Analysis) in QlikView

Ignore selection in an expression (Set Analysis)

Wed, 06 Jun 2012 17:48:36 GMT

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])

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.

nilesh_gangurde — Wed, 06 Jun 2012 17:58:26 GMT

Hi Hemant,

Use the below expression:

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

It will work.

Regards,

Nilesh Gangurde

Wed, 06 Jun 2012 18:03:10 GMT

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

Wed, 06 Jun 2012 18:26:29 GMT

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 — Wed, 06 Jun 2012 18:37:09 GMT

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

Wed, 06 Jun 2012 19:36:12 GMT

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

Thu, 07 Jun 2012 14:05:39 GMT

Thanks again! That helps.