topic Two dimensions in a single table mapping to one dimension in graph in App Development https://community.qlik.com/t5/App-Development/Two-dimensions-in-a-single-table-mapping-to-one-dimension-in/m-p/887265#M12331 <HTML><HEAD></HEAD><BODY><P>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:</P><P><BR />sum({&lt;RETURN_CATEGORY-={'Other returns','Not a return'},REF_WEEK=p(REF_WEEK_TRANS)&gt;} total &lt;REF_WEEK,RETURN_CATEGORY&gt; AMOUNT_RET)</P><P>/ (sum({$&lt;FEEDBACK={1},REF_WEEK_TRANS=p(REF_WEEK),RETURN_CATEGORY=&gt;} total &lt;REF_WEEK_TRANS&gt; TOTAL_AMOUNT))</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 22 Apr 2015 21:20:07 GMT 2015-04-22T21:20:07Z Two dimensions in a single table mapping to one dimension in graph https://community.qlik.com/t5/App-Development/Two-dimensions-in-a-single-table-mapping-to-one-dimension-in/m-p/887265#M12331 <HTML><HEAD></HEAD><BODY><P>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:</P><P><BR />sum({&lt;RETURN_CATEGORY-={'Other returns','Not a return'},REF_WEEK=p(REF_WEEK_TRANS)&gt;} total &lt;REF_WEEK,RETURN_CATEGORY&gt; AMOUNT_RET)</P><P>/ (sum({$&lt;FEEDBACK={1},REF_WEEK_TRANS=p(REF_WEEK),RETURN_CATEGORY=&gt;} total &lt;REF_WEEK_TRANS&gt; TOTAL_AMOUNT))</P><P></P><P>Any ideas?</P></BODY></HTML> Wed, 22 Apr 2015 21:20:07 GMT https://community.qlik.com/t5/App-Development/Two-dimensions-in-a-single-table-mapping-to-one-dimension-in/m-p/887265#M12331 2015-04-22T21:20:07Z