Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Help me with condition for giving multiple selection in set expression condition.
//This is not working
Try this
=Aggr(Only({1<Month={"$(=Getfieldselections(Month))"}>}Month),Month)
There could be multiple reasons why this is not working. Could you explain your context here? What are you trying to achieve?
My requirement is to display month wise in straight table based on selection of month.
Showing last 6 months or last 3 months from maximum month is working.
But this requirement is like selection of random months; selecting jun & jan should only display jun & jan.
If i select feb,jan & aug respective months alone need to shown.
My measures for table is almost 15, so instead of writing expression on each measure trying to achieve with Dimension condition.
Create a variable (variable1) as follows;
=concat(GetFieldSelections(Month))
Use this variable in your expression as follows
=sum({<Month={$(variable1)}>}Expression1)
Got solution from this link.
https://community.qlik.com/t5/New-to-QlikView/Set-Analysis-with-multiple-selections/td-p/996089