Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
buzzy996
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
dplr-rn
Partner - Master III
Partner - Master III

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

buzzy996
Master II
Master II
Author

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?

dplr-rn
Partner - Master III
Partner - Master III

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

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?