topic Re: Set Analysis and Slider in QlikView

Set Analysis and Slider

passionate — Tue, 08 Jan 2019 04:35:50 GMT

I have list of products, cost price and selling price.

There is use case to filter out products on front end with slider.

Eg:- If i select slider as 20 Percent than product having profit less than or equal to 20 percent should be filtered.

Products should be filtered on whole dashboard in all the calculations. i.e KPI, etc

Please help me with some front end solution.

Re: Set Analysis and Slider

kaushiknsolanki — Tue, 08 Jan 2019 07:39:58 GMT

Hi,

Check this out.

Regards,

Kaushik Solanki

Re: Set Analysis and Slider

sunny_talwar — Tue, 08 Jan 2019 13:27:07 GMT

May be create a OnChange Variable Event Trigger for vProfit where you trigger Select in Field on ProdCountry field (a new field created in the script) using the following expression

='=Only({<ProdCountry>} ([Selling Price]-[Cost Price])/[Cost Price]) <= vProfit/100'

Script for ProdCountry

LOAD ProductID, 
     Product, 
     [Cost Price], 
     [Selling Price], 
     Country,
     Product&Country as ProdCountry
FROM
[Slider Data.xlsx]
(ooxml, embedded labels, table is Sheet1);