Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
satishqlik
Contributor II

help me on this expression

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.

Tags (1)
5 Replies
passionate
Valued Contributor

Re: help me on this expression

Can you use GetSelectedCount in Qliksense?

passionate
Valued Contributor

Re: help me on this expression

PFA
Qlikview document

satishqlik
Contributor II

Re: help me on this expression

Thanks for response.

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

passionate
Valued Contributor

Re: help me on this expression

Please refer attached screen shots for expressions

satishqlik
Contributor II

Re: help me on this expression

Hi Sorry for my late response.

This  is what exactly am looking for

But in Qliksense how do we accomplish this requirement.

Thanks again!!