Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Slider and Pivot Table

I have two objects - a pivot table and a slider.

A slider contains a variable.
Changes in slider/variable should not affect the pivot table.
Is it possible to do that? If yes, how? Maybe with some kind of set analysis restrictions?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Slider and Pivot Table

Hi!

Deleting everything in the set condition except "Digital_Sale_IND" worked.

Thanks for your support.

12 Replies
Not applicable

Re: Slider and Pivot Table

Hi,

Have a look at Develop a what-if analysis with QlikView.

Regards,

Ananth

Re: Slider and Pivot Table

Hi,

What kind of analysis are you doing?

Can you post some sample data and qvw file to analyze further.

Regards

ASHFAQ

vardhancse
Valued Contributor II

Re: Slider and Pivot Table

In our expression if we want to change the value based on slider, then we can use teh slider variable in th expression.

If not slider value will not reflect in the pivot table.

Re: Slider and Pivot Table

Can you post sample application.

Regards

ASHFAQ

Not applicable

Re: Slider and Pivot Table

Hi!

Thanks for your reply.

The app is almost 400 MB big. Therefore, I cannot send it.

However the question is conceptual - is it possible make that changes in slider do not affect the pivot table?

Re: Slider and Pivot Table

Not applicable

Re: Slider and Pivot Table

Hi,

Find the attached application.

May help you out

Not applicable

Re: Slider and Pivot Table

Thx for the reply.

This is what I tried. Here is how the expression in the pivot table looks like:

sum({$<

  Phase_$(vDateType)_Month_Num={">=$(=$(vHD_MonateBack($(vDateType))))<=$(=max(Phase_$(vDateType)_Month_Num))"},

  Phase_$(vDateType)_Year_Num=,

  Digital_Sale_IND={1},

  $(vHD_MonateBackOffset) = 1

>} flagOfferOrder)

The variable vHD_MonateBackOffset is the variable contained in the slider.

However, when I change the variable in the slider, the changes are still reflected in pivot table, although I have set the vHD_MonateBackOffset = 1.

Why does it not work?

Not applicable

Re: Slider and Pivot Table

This is what I tried. Here is how the expression in the pivot table looks like:

sum({$<

  Phase_$(vDateType)_Month_Num={">=$(=$(vHD_MonateBack($(vDateType))))<=$(=max(Phase_$(vDateType)_Month_Num))"},

  Phase_$(vDateType)_Year_Num=,

  Digital_Sale_IND={1},

  $(vHD_MonateBackOffset) = 1

>} flagOfferOrder)

The variable vHD_MonateBackOffset is the variable contained in the slider.

However, when I change the variable in the slider, the changes are still reflected in pivot table, although I have set the vHD_MonateBackOffset = 1.

Why does it not work?

Community Browser