topic Re: Pivoting issue in QlikView

Pivoting issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am facing few pivoting issue in my application. One of dimension month/year I kept as cross table format. But it changing frequently between the selection.

For Ex:

When I select value 1 it showing cross table and when I am selecting other Value 2 it is displaying in normal column format. As I need to show "Month/Year" in cross tab format it looks difficult on every time.

Plz let me know the fix

-Jai

Re: Pivoting issue

qlikview979 — Tue, 16 May 2017 06:32:16 GMT

Hi,

can you please provide the sample app.

Re: Pivoting issue

Anonymous — Tue, 16 May 2017 07:02:41 GMT

Hi Mahesh,

I have attached sample screenshot. Here I have done 2 selection in the "Date" fields and u can see the format change between the 2 selection in the pivot table.

-Jai

Re: Pivoting issue

qlikview979 — Tue, 16 May 2017 07:09:50 GMT

Hi,

if you share the sample app ,we can easily identify the solution asap.

Re: Pivoting issue

ramasaisaksoft — Tue, 16 May 2017 14:21:36 GMT

Hi Ij,

May be it happens because of "Null Values" or else May be there is no association between the dimensions which you called into pivot table.

-->so try to remove the filter dimension in Pivot and check still you are getting same issue or not so that as per the requirement you can add or remove Dimension from that Pivot table.