help me on this expression

[satishqlik]

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.

[passionate]

Can you use GetSelectedCount in Qliksense?

[passionate]

PFA
Qlikview document

[satishqlik]

Thanks for response.

can you paste the script the here as am using personal edition.

[passionate]

Please refer attached screen shots for expressions

[satishqlik]

Hi Sorry for my late response.

This  is what exactly am looking for

But in Qliksense how do we accomplish this requirement.

Thanks again!!