6 Replies Latest reply: Jun 7, 2012 10:05 AM by Hemanth Babu+Shekar

# 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.

Thanks,

Hemanth.

• ###### Ignore selection in an expression (Set Analysis)

Hi Hemant,

Use the below expression:

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

It will work.

Regards,

Nilesh Gangurde

• ###### Ignore selection in an expression (Set Analysis)

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

• ###### Ignore selection in an expression (Set Analysis)

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 ?

• ###### Ignore selection in an expression (Set Analysis)

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

• ###### Ignore selection in an expression (Set Analysis)

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

• ###### Ignore selection in an expression (Set Analysis)

Thanks again! That helps.