Pivoting issue

[Anonymous]

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

[qlikview979]

Hi,

can you please provide the sample app.

[Anonymous]

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

[qlikview979]

Hi,

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

[ramasaisaksoft]

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.