How to referance data from column dimension in pivot

[Anonymous]

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 )

[sunny_talwar]

How are you getting 223? I see 233, is that what we are trying to change?

[Anonymous]

Hi Sunny,

My false, I put wrong number. You're correct (233). I am very new for QLIK Sense.

Original Expression

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

This is what I want to link with data from MonthNo column. if They show 9. I want to auto get 9, 10, 11 up to each column.

MONTHNo = {"9"}

[sunny_talwar]

But you are already getting 233 for coverage? Is that not what you want? What is the expected number you want to see for Coverage?

[Anonymous]

Let's me explain about the logic. Actually the coverage number will be difference for each month for example

Month 9 Coverage = 233

Month 10 Coverage = 245

Month 11 Coverage = 250

It's depend on month, but when I used sum total. This will get the full coverage. I tried to filter for month 9 by using MONTHNo = {"9"} but when the month change in pivot table It's still show data for month 9 which is 233.

so I would like to refer to month in column header which will change dynamically. for example 

Month 9 in column= MONTHNo = {"9"}  = 233

Month 10 in column = MONTHNo = {"10"} = 245

Month 11 in column = MONTHNo = {"11"}  = 250

Please advise

[sunny_talwar]

Try this

Sum({<$(mvLevelItem) , $(mvMeasureTME)  ,  $(mvCHANNEL_GT), $(mvViewPeriod_TY)>}TOTAL <MONTHNo> CoverageCust)

[Anonymous]

I've tried. It's still doesn't work. The results show all zero.

[sunny_talwar]

May be share a sample where we might be able to see the issue?

[Anonymous]

Please find sample in attached file. !

[sunny_talwar · Accepted solution]

May be like attached