topic How to combine 2 dimension into 1 new field in App Development https://community.qlik.com/t5/App-Development/How-to-combine-2-dimension-into-1-new-field/m-p/1823274#M67533 <P>Dear all,</P><P>I'm a newbie in Qlik Sense.<BR /><BR />I would like to combine 2 different dimensions into a single one.&nbsp;<SPAN>I have 4 fields:</SPAN></P><P>- Expected Amount<BR />- Expected Date</P><P>- Actual Amount<BR />- Actual Date</P><P>My aim is to create a single bar graph where to show Actual vs Expected, considering a single Date dimension (obtained as combination of Expected Date and Actual Date).<BR /><BR />i.e.&nbsp; 01/07/2021&nbsp; &nbsp; &nbsp; 100€ (actual amount)<BR />&nbsp; &nbsp; &nbsp; &nbsp; 15/07/2021&nbsp; &nbsp; &nbsp; 10€ (expected amount)</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(graph)&nbsp; &nbsp; &nbsp;jul 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100€ (measure 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€ (measure 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>Thank you in advance for your help</P> Tue, 20 Jul 2021 10:54:47 GMT orlando162 2021-07-20T10:54:47Z How to combine 2 dimension into 1 new field https://community.qlik.com/t5/App-Development/How-to-combine-2-dimension-into-1-new-field/m-p/1823274#M67533 <P>Dear all,</P><P>I'm a newbie in Qlik Sense.<BR /><BR />I would like to combine 2 different dimensions into a single one.&nbsp;<SPAN>I have 4 fields:</SPAN></P><P>- Expected Amount<BR />- Expected Date</P><P>- Actual Amount<BR />- Actual Date</P><P>My aim is to create a single bar graph where to show Actual vs Expected, considering a single Date dimension (obtained as combination of Expected Date and Actual Date).<BR /><BR />i.e.&nbsp; 01/07/2021&nbsp; &nbsp; &nbsp; 100€ (actual amount)<BR />&nbsp; &nbsp; &nbsp; &nbsp; 15/07/2021&nbsp; &nbsp; &nbsp; 10€ (expected amount)</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(graph)&nbsp; &nbsp; &nbsp;jul 2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100€ (measure 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€ (measure 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>Thank you in advance for your help</P> Tue, 20 Jul 2021 10:54:47 GMT https://community.qlik.com/t5/App-Development/How-to-combine-2-dimension-into-1-new-field/m-p/1823274#M67533 orlando162 2021-07-20T10:54:47Z