Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vinieme12
Esteemed Contributor II

Pivot Table Issue

Hi ,

The below is a snapshot of how the pivot table displays on Access Point.

What is causing the Problem here??

pivot_issue.JPG

The Pivot has a single field added two times as dimension of the table, once to show the legend (background) and second as text.

This is how it is on desktop

pivot_issue2.JPG

PS: Indent mode is unchecked.

Thanks

Vineeth

Tags (1)
8 Replies
stabben23
Honored Contributor

Re: Pivot Table Issue

Hi,

is there any macro to "hide" Dimension or something like that?

vinieme12
Esteemed Contributor II

Re: Pivot Table Issue

Nope, no macros

stabben23
Honored Contributor

Re: Pivot Table Issue

Share app or show snapshot on Dimensions?

vinieme12
Esteemed Contributor II

Re: Pivot Table Issue

pivot_issue3.JPG

I've added "ActivityGroup" twice , one just has background and transparent text ,

second just text and no background.

vinieme12
Esteemed Contributor II

Re: Pivot Table Issue

Hi rwunderlich‌ , tko

Any ideas what is causing the problem in  access point?

divya_anand
Contributor II

Re: Pivot Table Issue

Hi Vineeth,

How did you use 1 dimension twice in the table?

vinieme12
Esteemed Contributor II

Re: Pivot Table Issue

Click on 'AddCalculatedDimension' and enter the fieldname

vinieme12
Esteemed Contributor II

Re: Pivot Table Issue

Can some one please take a look?

Thanks

Vineeth

Community Browser