topic Re: Pivot table problems in QlikView

Pivot table problems

Mon, 17 Feb 2014 10:05:54 GMT

Hi all,

I got 2 pivot tables that do not respond toward my selections.

1st one containing the following information:

Total km's 2.. 3.. 4.. 5...

When i switch or select different values like only 2 weeks etc the total km's won't change it keeps showing me the total value instead of switching towards those 2 weeks. Another example if I check out that it won't count vehicles that didn't drive more then 100> km's it still keeps them included while the other 2-5 expressions/dimensions like average km etc do respond towards my selections. Only this first box doesn't seem to respond to anything.

Expression:

=SUM({$< Year = {$(=max(Year))} >} TotalDistance)/1000

Second one

Total Revenue

2..

3..

4..

Again 2-4 do respond towards my selection while the total revenue doesnt react towards any selection'.

Expression:

SUM({$< Year = {$(=max(Year))} >} Revenue)/1000

Re: Pivot table problems

MK_QSL — Mon, 17 Feb 2014 10:17:16 GMT

Dear Vincent,

Can you share your apps?

Re: Pivot table problems

Mon, 17 Feb 2014 10:33:42 GMT

Hi Manish,

My employee does not allow me to upload my app.

However if I change my expression towards this:

=SUM(TotalDistance)/1000

It starts responding towards my selections. So i am pretty sure it has something to do with:
=SUM({$< Year = {$(=max(Year))} >}

Re: Pivot table problems

MK_QSL — Mon, 17 Feb 2014 10:36:45 GMT

But you can always create a sample apps with dummy data similar to you original apps.

Sometimes its difficult to answer without checking apps.