Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

pivot table customization

Hello I got a pivot table with 4 dimensions D1, D2, D3, and D4

it also has 6 expressions

the first expression is supposed to be the YTD (year to date) summation of debit minus credit amounts

now since D4 is MonthYear I used the sum(aggr(sum(debit-credit),,D3)

now everything is just fine except that the first expression E1 is repeated foreach monthyear

however I only want this expression to appear once

is this possible?

thank you

I can walk on water when it freezes
3 Replies
raghavsurya
Partner - Specialist
Partner - Specialist

hi,

Can you pls upload a sample qvw file.

Regards,

Raghav

ali_hijazi
Partner - Master II
Partner - Master II
Author

attached is the pivot table that I'm working on

Regards

Ali M. Hijazi

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II
Author

how can I send you a 155MB qlikview document?

I can walk on water when it freezes