topic Re: Manually modifying current selections in QlikView

Manually modifying current selections

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am using a slider to select a predefined set of customers and was able to do this via set analysis aggregation method. However I would also like to select this list of this customers for analysis.

I've attempted to use Only() in Listbox, however it doesn't seem to work. Is there any other way I can change the current selection based on my slider?

Note: My slider value is not linked to any variable but rather it's a criteria of

If value is 1 then search past 1 month for XXX criteria (Count the number of customers)

else if 2 then search past 2 months for XXX criteria (Count the number of customers)

Thank you all!

Re: Manually modifying current selections

swuehl — Tue, 17 May 2016 15:13:49 GMT

could you upload a small sample QVW?

Re: Manually modifying current selections

Wed, 18 May 2016 02:52:29 GMT

Would it be Ok if I just rephrase my question and show an example data structure?

Data Structure

Person|Subject|Marks|Year

A,Math,0,2015

A,Math,0,2014

A,Science,50,2015

A,Science,80,2014

A,Com Science,75,2015

A,Com Science,50,2014

B,Math,50,2015

B,Math,0,2014

B,Science,0,2015

B,Science,50,2014

Assuming I want to allow users to have the flexibility of choosing

1. Selecting the list of persons where subject "XXX" is less than 50 for "X" years

2. Selecting the list of persons where subject "XXX" is less than 50

In both 1 & 2, I would need the charts to change according to user's input of subject and years.Thus, is there any way I can submit a SQL query like method into the current selection box?