topic Re: ignore current selection from Chart in QlikView

ignore current selection from Chart

venkatg6759 — Mon, 23 Mar 2015 19:11:23 GMT

Hi Everyone,

I am using the below expression

sum({$<Rating={">7"}>}Sales) / sum ( Total <[Entity Name]> Sales)

Chart should not change when user selects rating from list box ,but it should change to all other listboxes.

I tried using 1 instead of $ but no use , even

sum({$<Rating={">7"},Rating=>}Sales) / sum ( Total <[Entity Name]> Sales)

Any Ideas,

Thanks,

Venkata

Gysbert_Wassenaar — Mon, 23 Mar 2015 19:26:08 GMT

Try sum({$<Rating={">7"}>}Sales) / sum ({<Rating=>} Total <[Entity Name]> Sales)

Anonymous — Mon, 23 Mar 2015 19:28:45 GMT

Try this:

sum({$<Rating={">7"}>}Sales) / sum ({<Rating = [1]::Rating>} Total <[Entity Name]> Sales)

Edit: The one above is less convoluted. Use that.