Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Two dimensions in a single table mapping to one dimension in graph

Hey guys, my question is on Qlik Sense. I have an app with a single table, and columns REF_WEEK and REF_WEEK_TRANS (which are weeks) are part of it. My graphs have REF_WEEK_TRANS as a dimension. However, my measure must use REF_WEEK for part of it, and REF_WEEK_TRANS for another part of it, and I didn't manage to tell Qlik that it should match the values from REF_WEEK to REF_WEEK_TRANS. Right now, the measure is defined as:


sum({<RETURN_CATEGORY-={'Other returns','Not a return'},REF_WEEK=p(REF_WEEK_TRANS)>} total <REF_WEEK,RETURN_CATEGORY> AMOUNT_RET)

/ (sum({$<FEEDBACK={1},REF_WEEK_TRANS=p(REF_WEEK),RETURN_CATEGORY=>} total <REF_WEEK_TRANS> TOTAL_AMOUNT))

Any ideas?

Tags (2)
Community Browser