Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

charts vs sliders

hi,

if we move slider one (postcode slider), values only need to be change on "PostCode vs Sales" chart.

if we move slider two (SalesId), values only need to change on "SalesId vs Sales" chart.

any help?

 

thanks

4 Replies
Highlighted
Partner
Partner

Re: charts vs sliders

Use set analysis

Change your expression in PostCode vs Sales to 

=sum( {<SalesID=>} Sales)

basically the new addition ignores selection of SalesID

SalesID vs Sales

=sum({<PostCode=>}Sales)

ignores selection of PostCode

Highlighted
Master II
Master II

Re: charts vs sliders

hi,thanks for this..looks correct but in my case i'm using

dimension as : monthname(enddate)

expression:=AVG(Date([Startdate],'DD/MM/YYYY')-Date([Enddate],'DD/MM/YYYY'))

so , how to use/place in the above expression?

Highlighted
Partner
Partner

Re: charts vs sliders

Move the dimension to the script (this is better for performance too) i.e. create a new column e.g.
monthname(enddate) as Month
Highlighted
Master II
Master II

Re: charts vs sliders

if tht is the case we have to create multiple expressions for each month separately, i think tht's not a good idea!

any other help?