Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i am new to qlikview and set analysis.
I have column called Key in the Table,
which has below data value.
key
1
2
3
4
5
I want to select records where Key = 4 on the line chart irrespective of selection.
How we can do this in set analysis ?
What kind of calculation are you trying to do? You can do something like:
=sum({1<Key = {4}>}field2)
building off Robert's example, this should allow you to select records where key = 4, but irrespective of any selections:
=sum({1<Key = {4}>}field2)
thanks.
let say , i want to put two fields with And criteria,
what would be the syntax ?
let say
Key = 4 AND Report Month = Jan 2014
how we can put in set expression ?
=sum({1<Key={4}, [Report Month]={'Jan 2014'}>} field2)
Eduardo
You want the Month selection Static or Dynamic?
Consider that you have Month Field as 'MMM YYYY' and want to have dynamic solution, use below
SUM({1<Key = {4}, Month = {'$(=Date(Max(DateField),'MMM YYYY'))'}>}Sales)