Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Gopi_E
Creator II
Creator II

How to remove aggregated column for one dimension value in pivot table when we use ValueList() as Dimension

Hi Qlikers,

I hope everyone doing well !!,

I have one scenario where in pivot table, I have added ValueList pivoted Dimension(MTD,YTD) to display different group of data. but the issue is, Measure-1 I just need it for MTD It shouldn't be in YTD, where as Measure-2 I should display for both MTD and YTD. For Measure-1 YTD. Is it possible to achieve this view ?

Here is the example picture -

Gopi_E_0-1673500909888.png

Thank you in Advance !!

1 Reply
williejacobs
Creator
Creator

Hi @Gopi_E 

The best solution I think would be to create 3 measures for your pivot table.

MTD - Measure 1, MTD - Measure 2, and YTD - Measure 3. 
Then add all 3 of these to your pivot.
A bit more work, but you should achieve the required result.