topic Re: Total with dimension value in QlikView https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304275#M406122 <HTML><HEAD></HEAD><BODY><P>Thanks all, </P><P></P><P>I will try all the options you suggested and get back with what worked for me.</P><P></P><P>Cheers </P></BODY></HTML> Wed, 12 Apr 2017 11:01:56 GMT didierodayo 2017-04-12T11:01:56Z Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304268#M406115 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>in the sample document attached below, I am trying to set the Total row as&nbsp; (Total A) and Total (B) . basically I need the dimension value added in front of the total.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159812_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Any suggestion for achieving this is appreciated.</P><P>Thanks</P></BODY></HTML> Wed, 12 Apr 2017 05:00:36 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304268#M406115 didierodayo 2017-04-12T05:00:36Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304269#M406116 <HTML><HEAD></HEAD><BODY><P>I don't think so whether we have feature in it. Let's see whether some one offer you because. If it is one expression then it could possible. Let them back to thread.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ <A href="https://community.qlik.com/qlik-users/27943">marcus_sommer</A>‌ <A href="https://community.qlik.com/qlik-users/93783">okg</A>‌</P></BODY></HTML> Wed, 12 Apr 2017 09:13:20 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304269#M406116 Anil_Babu_Samineni 2017-04-12T09:13:20Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304270#M406117 <HTML><HEAD></HEAD><BODY><P>May be a work around</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159845_Capture.PNG" style="height: 197px; width: 620px;" /></P></BODY></HTML> Wed, 12 Apr 2017 09:32:20 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304270#M406117 sunny_talwar 2017-04-12T09:32:20Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304271#M406118 <HTML><HEAD></HEAD><BODY><P>Another solution..</P><P>But with date selection this will not respond.. so have to do some work around for that.</P></BODY></HTML> Wed, 12 Apr 2017 09:43:56 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304271#M406118 MK_QSL 2017-04-12T09:43:56Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304272#M406119 <HTML><HEAD></HEAD><BODY><P>you will need to change a model to achieve that </P></BODY></HTML> Wed, 12 Apr 2017 09:46:48 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304272#M406119 annafuksa1 2017-04-12T09:46:48Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304273#M406120 <HTML><HEAD></HEAD><BODY><P>Here we go!</P></BODY></HTML> Wed, 12 Apr 2017 10:12:30 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304273#M406120 MK_QSL 2017-04-12T10:12:30Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304274#M406121 <HTML><HEAD></HEAD><BODY><P>Another workaround...</P><P></P><P></P><P><IMG alt="Dimension_in_subtotal_pivot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159853_Dimension_in_subtotal_pivot.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 12 Apr 2017 10:20:58 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304274#M406121 Anonymous 2017-04-12T10:20:58Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304275#M406122 <HTML><HEAD></HEAD><BODY><P>Thanks all, </P><P></P><P>I will try all the options you suggested and get back with what worked for me.</P><P></P><P>Cheers </P></BODY></HTML> Wed, 12 Apr 2017 11:01:56 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304275#M406122 didierodayo 2017-04-12T11:01:56Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304276#M406123 <HTML><HEAD></HEAD><BODY><P>PFA.</P><P></P><P>may be my solution will match from one of the solution given above as I have not seen what other replied <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 12 Apr 2017 12:47:43 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304276#M406123 Kushal_Chawda 2017-04-12T12:47:43Z Re: Total with dimension value https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304277#M406124 <HTML><HEAD></HEAD><BODY><P>All the steps suggested arrive at the end result I just used what worked well for my data.</P><P></P><P>thanks everyone.</P></BODY></HTML> Thu, 13 Apr 2017 02:10:15 GMT https://community.qlik.com/t5/QlikView/Total-with-dimension-value/m-p/1304277#M406124 didierodayo 2017-04-13T02:10:15Z