topic Re: Fast change calculated dimensions are not working on Server for Pivot table in QlikView

Fast change calculated dimensions are not working on Server for Pivot table

Fri, 20 Mar 2015 04:44:11 GMT

Hi,

I have a fast change between Pivot table and Straight table, and I am facing this strange problem, calculated dimensions are not working on server for Pivot table but working for straight table and same qvw working fine on my desktop edition. Please suggest if anyone has faced the same issue.

Regards,

Navdeep

Re: Fast change calculated dimensions are not working on Server for Pivot table

simsondevadoss — Fri, 20 Mar 2015 04:46:22 GMT

It should work. Can you clear browser cache and try again?

Re: Fast change calculated dimensions are not working on Server for Pivot table

Fri, 20 Mar 2015 05:10:37 GMT

Hi Sim,

Tried, no success, is it because of Qlikview version? I have 11.20 SR 10 on my system and SR 1 on server. But I never had this kind of issue.

Re: Fast change calculated dimensions are not working on Server for Pivot table

simsondevadoss — Fri, 20 Mar 2015 06:03:54 GMT

Yes. Please use latest version in server also. There might be a Bug.

Re: Fast change calculated dimensions are not working on Server for Pivot table

Roop — Fri, 20 Mar 2015 10:28:47 GMT

You may well have to use Aggr(.....) function for your pivot table.

I would try the pivot table on its own first and see if it works.

See also Sum of Rows in Pivot Tables in the help files