topic Re: 1 slider pointing to 2 data columns in QlikView

1 slider pointing to 2 data columns

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all ,

I have one slider object on the report and 2 column values "Rating Scale" and "Requirement Scale" which consists of entries from 0 to 10.

how do i create one slider so that when i filter the slider it searches the data in both the column and result the data.

kindly suggest on how to achieve this .

Thanks & Regards

HarishG — Wed, 04 Apr 2018 12:13:43 GMT

Hi,

Can you elaborate your scenario?

Anonymous — Thu, 05 Apr 2018 05:39:25 GMT

Hi Harish ,

I have 2 columns for ratings , "Current Rating " and "Requirement Rating" , values in these 2 columns are from 0 to 10.

now on the report i have a filter called Product type (list box) which has 2 values "Current" and "Recommended"

and i also have a slider .

now the requirement is when i select "Current " in the product type filter i want the slider to reflect "Current Rating" column values .

and when i select "Recommended " in the product type filter i want the slider to reflect "Recommended Rating" column values .

this has to be achieved on the single slider option available in the report.

Kindly suggest on how to achieve this.

Thanks in advance

HarishG — Thu, 05 Apr 2018 06:28:58 GMT

If you are using Field in the slider, then you can write the expression below,

=if(Product type='Current',Current Rating,Requirement Rating).