Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a requirement on line chart in Qlikview/Qliksense, Please find the below attachment
>by defalut it has to show Sum(Vol)....(if no selections made)
>If I select any brand it has to show 2lines
one line with Sum(act) and another line with Sum(fore)
I have created two saparate line charts with Sum(Vol) and another line chart with Valuelist.
But I want to show both requirements in single line chart(to put both expressions in single line chart) based on these conditions.
I have tried with Getselections but not working.
Dim1: Year
Dim2: If(GetSelectedCount(Brand)=0,brand,ValueList('_Act', '_Fore'))
If(GetSelectedCount(Brand)=0, Sum(Vol), Pick(Match(ValueList('_Act', '_Fore'), '_Act','_Fore'), Sum(act),Sum(fore)) .
Any suggestions will be appreciated.
Please help me out in this.
Can you use GetSelectedCount in Qliksense?
PFA
Qlikview document
Thanks for response.
can you paste the script the here as am using personal edition.
Please refer attached screen shots for expressions
Hi Sorry for my late response.
This is what exactly am looking for
But in Qliksense how do we accomplish this requirement.
Thanks again!!