Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
sateeshkumar
Creator
Creator

pivot table with custom dimention and month

Hi,

i am facing an issue with pivot table. I have one inline and also have year_month as dimention. So i want pivot table with last 6 months data. whereas each row in inline column having different expression. When i tried to develop this by using pick(match...) condition, it is displaying only latest month.All other months having null values.

below is my expreesion for one row.

pick(match(dim_1,'value1','value2',...),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric1),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric2)...)


So please help me to solve this issue.


Thanks

5 Replies
sunny_talwar

Have you made any selection in the month field?

sateeshkumar
Creator
Creator
Author

Yes, I have filter for Month,But I am restricting it in Expreesion like below.

pick(match(dim_1,'value1','value2',...),

Only({<year=,month=,Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric1),

Only({<year=,month=,Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric2)...)


sunny_talwar

May be try this

Pick(Match(Only({1} dim_1),'value1','value2',...),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}, Month>}metric1),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}, Month>}metric2)...)

sateeshkumar
Creator
Creator
Author

Tried, but No luck