Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

A general pivot query

Hello Experts,

The below espression works fine with a straight table, where Calendar.YearMonth is the dimension moved to the top as header. However when I change the straight table to Pivot, the AGGR part doesnt work and it simply shows the month values... Any ideas and suggestiong is highly appreciated.

=(sum(AGGR($(fnCashToMonthCV),Calendar.YearMonth)))

Thanks in Advance,

Mady

1 Reply
lironbaram
Partner - Master III
Partner - Master III

hei

just an idea

if you have other dimensions in the pivot table

you need to include them in your aggr function