Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bhaveshp90
Contributor III

Slider and Straight table

Hello, 

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

1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

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

 

 

 

Labels (2)
2 Solutions

Accepted Solutions
dilipranjith
Honored Contributor

Re: Slider and Straight table

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

AlbertoV
Contributor III

Re: Slider and Straight table

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

 

4 Replies
dilipranjith
Honored Contributor

Re: Slider and Straight table

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

bhaveshp90
Contributor III

Re: Slider and Straight table

@dilipranjith  I've attached the file in the question. 

dilipranjith
Honored Contributor

Re: Slider and Straight table

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

AlbertoV
Contributor III

Re: Slider and Straight table

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