Slider and Pivot Table

[#1]

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?

[#2]

Hi,

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

Regards,

Ananth

[ashfaq_haseeb]

Hi,

What kind of analysis are you doing?

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

Regards

ASHFAQ

[vardhancse]

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.

[ashfaq_haseeb]

Can you post sample application.

Regards

ASHFAQ

[#6]

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?

[ashfaq_haseeb]

Again,

I don't know why you are using slider.

have a look at attached post.

http://community.qlik.com/docs/DOC-3098

http://community.qlik.com/docs/DOC-2380

Preparing examples for Upload - Reduction and Data Scrambling

Regards

ASHFAQ

[#8]

Hi,

Find the attached application.

May help you out

[#9]

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?

[#10]

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?