Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to referance data from column dimension in pivot

Clipboard01.bmp

Quick question. I have column MONTHNo. I need to get data from those column like 9, 10, 11

I got query for coverage which used some total. I need data from column in pivot to help me scope data each month so that I will get same number 223. my expression below. Please advise.

Sum( {<$(mvLevelItem) , $(mvMeasureTME)  ,  $(mvCHANNEL_GT), $(mvViewPeriod_TY), MONTHNo = {"9"}  >}  Total  CoverageCust )

10 Replies
Anonymous
Not applicable
Author

It's work perfectly. Thank you, but this is a bit difficult for me. Is it possible to explain your expression?

If(Column(1), Only({<$(mvLevelItem), $(mvMeasureTME), $(mvCHANNEL_GT)>}

Aggr(NODISTINCT Sum({<$(mvLevelItem), $(mvMeasureTME), $(mvCHANNEL_GT)>} CoverageCust), MONTHNo)))