Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
Not applicable
Author

Hi!

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

Thanks for your support.

View solution in original post

12 Replies
Not applicable
Author

Hi,

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

Regards,

Ananth

ashfaq_haseeb
Champion III
Champion III

Hi,

What kind of analysis are you doing?

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

Regards

ASHFAQ

vardhancse
Specialist III
Specialist III

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
Champion III
Champion III

Can you post sample application.

Regards

ASHFAQ

Not applicable
Author

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
Champion III
Champion III

Not applicable
Author

Hi,

Find the attached application.

May help you out

Not applicable
Author

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
Author

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?