Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
Partner
Partner

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


6 Replies
Partner
Partner

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


Not applicable

Ignore selection in an expression (Set Analysis)

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

Not applicable

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 ?

Partner
Partner

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

Not applicable

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.

Not applicable

Ignore selection in an expression (Set Analysis)

Thanks again! That helps.