Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

6 Replies
Not applicable

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

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)

Not applicable

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

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

Not applicable

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

I don't understand what you want.

Can you post an example?

Not applicable

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

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.

dennisnet
Valued Contributor III

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

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

Properties >> General >> check Smiley Very Happyetached

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

Not applicable

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

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.

Community Browser