topic Re: Modelisation Problem in QlikView https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601292#M222445 <HTML><HEAD></HEAD><BODY><P>a straight table with Name as dimension and sum(units) as expression would do it. Or a pivot, so that you can also show details like CCN and SN.</P><P>Hope I understood well <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Feb 2014 15:11:10 GMT giakoum 2014-02-18T15:11:10Z Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601287#M222440 <HTML><HEAD></HEAD><BODY><P>Hello Evereybody :</P><P></P><P>I have a table :</P><P></P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CCN</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">SN</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Units</TH></TR><TR><TD style="padding: 2px;">11100_FRA000094242</TD><TD style="padding: 2px;">Sophie Loft</TD><TD style="padding: 2px;">26105656112103</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">11100_FRA000094242</TD><TD style="padding: 2px;">Sophie Loft</TD><TD style="padding: 2px;">266434257352123</TD><TD style="padding: 2px;">18</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>&nbsp; In my Dashboard i want to have</P><P></P><P></P><P>Sophie&nbsp;&nbsp;&nbsp; Loft ======================&gt; CCN 1:&nbsp; 11100_FRA0000990158 ,&nbsp;&nbsp; Units : 12</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CCN2 : 11100_FRA0000980114&nbsp; , Units&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Maybe i Should use a concatenation&nbsp;&nbsp;&nbsp; ???</P></BODY></HTML> Tue, 18 Feb 2014 14:57:19 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601287#M222440 2014-02-18T14:57:19Z Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601288#M222441 <HTML><HEAD></HEAD><BODY><P>really not very clear what you are trying to achieve. Please elaborate a little.</P></BODY></HTML> Tue, 18 Feb 2014 14:59:30 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601288#M222441 giakoum 2014-02-18T14:59:30Z Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601289#M222442 <HTML><HEAD></HEAD><BODY><P><BR />Hi Ben Bourahel,</P><P></P><P>yes - you need a concatenation (the &amp;, upper_quotes for the text_elements) and a rowno() for that "CCN1 CCN2".</P></BODY></HTML> Tue, 18 Feb 2014 15:00:36 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601289#M222442 datanibbler 2014-02-18T15:00:36Z Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601290#M222443 <HTML><HEAD></HEAD><BODY><P>Hi Ben,</P><P></P><P>Yes, you can use string concatenation but which object are you using? Please can you give more details. I can't fully follow your question.</P><P></P><P>Thanks,</P><P>DV</P></BODY></HTML> Tue, 18 Feb 2014 15:01:55 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601290#M222443 IAMDV 2014-02-18T15:01:55Z Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601291#M222444 <HTML><HEAD></HEAD><BODY><P>IOANNIS </P><P></P><P>In this example, I have the same person (sophie) , with two different CCN and SN numbers ,So&nbsp; what I want to do is: for the same person display the total of such units( units of sophie)</P></BODY></HTML> Tue, 18 Feb 2014 15:06:52 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601291#M222444 2014-02-18T15:06:52Z Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601292#M222445 <HTML><HEAD></HEAD><BODY><P>a straight table with Name as dimension and sum(units) as expression would do it. Or a pivot, so that you can also show details like CCN and SN.</P><P>Hope I understood well <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Feb 2014 15:11:10 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601292#M222445 giakoum 2014-02-18T15:11:10Z Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601293#M222446 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Ben,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Try creating a unique field which is concatenation of all the fields with Autonumber() or Hash key. Then use this field as the hidden dimension and show other required dimensions.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P></BODY></HTML> Tue, 18 Feb 2014 15:14:32 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601293#M222446 IAMDV 2014-02-18T15:14:32Z Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601294#M222447 <HTML><HEAD></HEAD><BODY><P>Hello , Deepak ,</P><P></P><P>See a little example in the attachement</P></BODY></HTML> Tue, 18 Feb 2014 15:20:14 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601294#M222447 2014-02-18T15:20:14Z Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601295#M222448 <HTML><HEAD></HEAD><BODY><P>Do you have an example please&nbsp; ,&nbsp; I debuted on qlikview <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Feb 2014 15:26:21 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601295#M222448 2014-02-18T15:26:21Z Re: Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601296#M222449 <HTML><HEAD></HEAD><BODY><P>see attached</P></BODY></HTML> Tue, 18 Feb 2014 15:33:00 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601296#M222449 giakoum 2014-02-18T15:33:00Z Re: Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601297#M222450 <HTML><HEAD></HEAD><BODY><P>or even better ... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 18 Feb 2014 15:37:58 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601297#M222450 giakoum 2014-02-18T15:37:58Z Re: Re: Modelisation Problem https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601298#M222451 <HTML><HEAD></HEAD><BODY><P>Thank U </P></BODY></HTML> Tue, 18 Feb 2014 15:43:41 GMT https://community.qlik.com/t5/QlikView/Modelisation-Problem/m-p/601298#M222451 2014-02-18T15:43:41Z