topic Re: Slider and Straight table in QlikView

Slider and Straight table

bhaveshp90 — Sat, 16 Nov 2024 03:49:00 GMT

Hello,

I've created a slider and straight table as shown below.

Can anyone tell me how can I apply the changes so that the slider change will filter the table using "Calc. POC" column as highlighted above? Attached is the file for reference

thanks

Re: Slider and Straight table

dplr-rn — Thu, 18 Apr 2019 12:54:18 GMT

You can use set analysis to do so.

But exactly how depends on your data.

can you share a sample of your data and the expression used in your table

Re: Slider and Straight table

bhaveshp90 — Thu, 18 Apr 2019 15:16:07 GMT

@dplr-rn I've attached the file in the question.

Re: Slider and Straight table

dplr-rn — Thu, 18 Apr 2019 15:32:10 GMT

Simplest way
change project dimension to below

=if(
Aggr((Sum({<[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual])
/
Sum({<[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected])
),[ORA Project Number],Engineering_Manager)*100<=var_PoC_Slider,
[ORA Project Number])

not sure if thats the most efficient way.
Will check if theres a set analysis way to achieve it

Re: Slider and Straight table

albertovarela — Thu, 18 Apr 2019 16:06:32 GMT

Take a look at the attached qvw...

I updated the [ORA Project Number] to be calculated based on Calc. POC expression; if less or equal than ... show the dim value otherwise make it null.

I hope you find it useful