topic Selection in one pivot table object should not be reflected in another pivot table object in same sheet in QlikView

Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Wed, 11 May 2011 14:47:05 GMT

Hi,

I have a application where are two pivot table charts and some calender selection objects are there like Year, Month, Quarter, Current Week, Yesterday, Sales manager, Manager. I have a query that if i select some calender selection like Year, Month, Current Week, Yesterday, Quarter then it will reflect only single pivot table and data should change according to data but another pivot table chart will unchange when i select Year, Month, Quarter, Current Week, Yesterday. Also when i select Sales manager, Manager it will change. Please provide help for that.

Anand

Re: Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Wed, 11 May 2011 15:30:11 GMT

Use a set analysis to "modify" the selection the graph think it is.

Example:

Let's say the graph that changes when a calendar dimension is selected have the following expression

=sum(Sales)

then, in the graph that has no change on "Year", "Month", "Day", "XXX" dimensions, you should have the following expression instead

=sum({$ <Year=, Month=, Day=, XXX=>} Sales)

Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Wed, 11 May 2011 16:55:08 GMT

Hi,

Thanks for this but i have a current selection type of filed which has occupy two types of data like

Current Selection = Yesterday,Current Week. In this two types of data at a time we can select only once and i want to does not reflect the values in second pivot table chart.

Please send me details.

Anand

Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Wed, 11 May 2011 17:23:19 GMT

I don't understand what you want.

Can you post an example?

Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Thu, 12 May 2011 10:45:22 GMT

I want to apply this type of condition like

=sum({$ <Year=, Month=, Day=, XXX=>} Sales)

To Inline type of load values like

CalendarChoices:

LOAD dual(CalendarChoice, CalendarChoiceNum) as CalendarSelection

INLINE [

CalendarChoice, CalendarChoiceNum

Yesterday, 1

Current Week, 2

];

Here we have selections like "Yesterday", "Current Week".

The code you suggested

=sum({$ <Year=, Month=, Day=, XXX=>} Sales)

It is works for the Year, Month, day etc. But i want to aply for "Yesterday", "Current Week" but it is single object or in single CalendarSelection values so please suggest me.

Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Anonymous — Thu, 12 May 2011 11:45:34 GMT

Isn't it an option to detacht the second pivot table?

Properties >> General >> check :Detached

Or does it need to change when you select something else?

Re: Selection in one pivot table object should not be reflected in another pivot table object in same sheet

Thu, 12 May 2011 11:47:02 GMT

Let's say you have the following data:

TblData:

LOAD * INLINE [

Date, User, Value

01/01/2011, Toto, 1

02/01/2011, Toto, 1

03/01/2011, Toto, 1

10/05/2011, Toto, 20

12/05/2011, Toto, 300

14/05/2011, Toto, 20

12/10/2011, Toto, 4

]

;

CalendarChoices:

LOAD dual(CalendarChoice, CalendarChoiceNum) as CalendarSelection

INLINE [

CalendarChoice, CalendarChoiceNum

All, 0

Today, 1

Current Week, 2

];

If you have a ListBox element for CalendarSelection with "always 1 selected value" checked, you can use the condition:

sum(if(
    (CalendarSelection = 1 and Date = today()) or 
    (CalendarSelection = 2 and week(Date) = week(today())) or
    CalendarSelection = 0
, Value))

Another solution is to add a flag in your load script on your data table to say for each field if it's "today", "this week", or watever you want.