Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krishnacbe
Valued Contributor III

Exclude selection of a dimension using SET expression

Hi All,

I am new to Qliksense. I am trying to exclude as dimension selection in my expression.

It works fine in Qlikview but in Qlik Sense it shows 0.

Eg:

Sum({<Year=>}Sales)

Trying to exclude Year selection. But it is not working, if I select any values in Year it is reflection in the charts.

Thanks in advance.

1 Solution

Accepted Solutions
krishnacbe
Valued Contributor III

Re: Exclude selection of a dimension using SET expression

The Year Filter I have used was Calculated Dimension. I moved the calculation to scripting, it worked perfectly.

Thanks

3 Replies
agigliotti
Honored Contributor II

Re: Exclude selection of a dimension using SET expression

are you sure you have only one expression in your chart?

and the field name is exactly "Year"?

krishnacbe
Valued Contributor III

Re: Exclude selection of a dimension using SET expression

Yes, the field name is correct.

I tried copying the expression in text object as well. But no luck.

krishnacbe
Valued Contributor III

Re: Exclude selection of a dimension using SET expression

The Year Filter I have used was Calculated Dimension. I moved the calculation to scripting, it worked perfectly.

Thanks

Community Browser