topic Re: Slider and Pivot Table in QlikView

Slider and Pivot Table

Mon, 08 Sep 2014 08:55:15 GMT

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?

Re: Slider and Pivot Table

Mon, 08 Sep 2014 09:09:11 GMT

Hi,

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

Regards,

Ananth

Re: Slider and Pivot Table

ashfaq_haseeb — Mon, 08 Sep 2014 09:26:15 GMT

Hi,

What kind of analysis are you doing?

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

Regards

ASHFAQ

Re: Slider and Pivot Table

vardhancse — Mon, 08 Sep 2014 09:29:14 GMT

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

ashfaq_haseeb — Mon, 08 Sep 2014 09:30:06 GMT

Can you post sample application.

Regards

ASHFAQ

Re: Slider and Pivot Table

Mon, 08 Sep 2014 09:50:10 GMT

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

ashfaq_haseeb — Mon, 08 Sep 2014 09:55:15 GMT

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

Re: Slider and Pivot Table

Mon, 08 Sep 2014 10:08:16 GMT

Hi,

Find the attached application.

May help you out

Re: Slider and Pivot Table

Mon, 08 Sep 2014 10:58:07 GMT

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?

Re: Slider and Pivot Table

Mon, 08 Sep 2014 12:04:11 GMT

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?

Re: Slider and Pivot Table

ashfaq_haseeb — Mon, 08 Sep 2014 12:08:25 GMT

Hi,

You cannot assign value to a variable like that, simple try below

sum({$<

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

Phase_$(vDateType)_Year_Num=,

Digital_Sale_IND={1}

>} flagOfferOrder)

Let me know if that worked.

Edit:

Make sure your slider variable is not used in any other expressions.

Regards

ASHFAQ

Re: Slider and Pivot Table

Wed, 10 Sep 2014 07:58:17 GMT

Hi!

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

Thanks for your support.

Re: Slider and Pivot Table

ashfaq_haseeb — Wed, 10 Sep 2014 07:59:23 GMT

Glad to know that

Can you close this thready by selecting appropriate answers.

Regards

ASHFAQ