topic charts vs sliders in QlikView

charts vs sliders

buzzy996 — Thu, 09 May 2019 12:01:17 GMT

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

dplr-rn — Thu, 09 May 2019 16:58:44 GMT

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 — Fri, 10 May 2019 11:11:37 GMT

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 — Fri, 10 May 2019 19:34:25 GMT

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 — Mon, 13 May 2019 11:12:59 GMT

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?