Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
arjakumar
New Contributor III

How to reflect my charts based on selection in Qlik Sense?

How to reflect my charts based on selection in Qlik Sense?
Hi

I have product,customer,country,region, year fields.and i am creating two charts.one is bar chart other one line chart.

my requirement is when i select product and customer list box it reflect the bar chart.

when i select year,region and country in list box it reflect the line chart .

3 Replies
Channa
Valued Contributor III

Re: How to reflect my charts based on selection in Qlik Sense?

try with Alternate states

hear you can remove or create connection between objects

Channa
VishalWaghole
Valued Contributor II

Re: How to reflect my charts based on selection in Qlik Sense?

While creating expression for bar chart you can excluded year,region and country like below

Sum({<year=,region=, country=>} sales)

And for line chart use below

Sum({<customer=, product=>} sales)

Regards,
Vishal Waghole
Channa
Valued Contributor III

Re: How to reflect my charts based on selection in Qlik Sense?

if want to exclude just add

 

=sum ( {<Year = ,region=,..>} TotalSuggestions)

Channa