Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
arjakumar
Contributor III
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
Specialist III
Specialist III

try with Alternate states

hear you can remove or create connection between objects

Channa
VishalWaghole
Specialist II
Specialist II

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
Specialist III
Specialist III

if want to exclude just add

 

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

Channa