topic Re: issue with calculated dimension in QlikView https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542127#M202627 <HTML><HEAD></HEAD><BODY><P>What if you add them as separate dimensions? Something like the attachment.</P><P></P><P>Rgds</P><P>Abey</P></BODY></HTML> Wed, 28 Aug 2013 15:15:25 GMT abeyphilip 2013-08-28T15:15:25Z issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542123#M202623 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I have two field which represent years. I want to create an histogram from this two field. To do that I created the below calculated</P><P>dimension :</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_ANNEE</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">num_annee</SPAN><SPAN style="font-size: 8pt;"> )&nbsp; </SPAN></P><P></P><P>The problem is, when I select Two years, I get an average (only one bar in the histogram) whereas I would like to get 2 bars : one for each year.</P><P></P><P>Please find attached a screenshot.</P><P></P><P>Thak you for your help.</P></BODY></HTML> Wed, 28 Aug 2013 14:11:25 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542123#M202623 2013-08-28T14:11:25Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542124#M202624 <HTML><HEAD></HEAD><BODY><P>Hi Anth,</P><P></P><P>Wouldn't making the year as dimension helps?</P><P></P><P>Regards,</P><P>Abey</P></BODY></HTML> Wed, 28 Aug 2013 14:42:00 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542124#M202624 abeyphilip 2013-08-28T14:42:00Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542125#M202625 <HTML><HEAD></HEAD><BODY><P>You should use Year as dimension instead of <SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">aggr</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">( </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">NUM_ANNEE</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">, </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">num_annee</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> ) </SPAN></P></BODY></HTML> Wed, 28 Aug 2013 14:50:05 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542125#M202625 CELAMBARASAN 2013-08-28T14:50:05Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542126#M202626 <HTML><HEAD></HEAD><BODY><P>No, it doesn't work because if I put only one year as a dimension, the other is not taking into account.</P><P>I need to get a bar for num_annee=2009 and NUM_ANNEE=2009, another for num_annee=2010 and NUM_ANNEE=2010 ect..</P><P>I'm pretty sure I should use a calculated dimension and the aggr function but I don't know exactly how..</P></BODY></HTML> Wed, 28 Aug 2013 14:50:27 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542126#M202626 2013-08-28T14:50:27Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542127#M202627 <HTML><HEAD></HEAD><BODY><P>What if you add them as separate dimensions? Something like the attachment.</P><P></P><P>Rgds</P><P>Abey</P></BODY></HTML> Wed, 28 Aug 2013 15:15:25 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542127#M202627 abeyphilip 2013-08-28T15:15:25Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542128#M202628 <HTML><HEAD></HEAD><BODY><P>It's not what I want. In your way, I get 2 bars for 2009, 2 bars for 2010... And I want only one bar for each but which take into acount both sélections..</P></BODY></HTML> Thu, 29 Aug 2013 07:18:18 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542128#M202628 2013-08-29T07:18:18Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542129#M202629 <HTML><HEAD></HEAD><BODY><P>No one?</P></BODY></HTML> Fri, 30 Aug 2013 10:11:28 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542129#M202629 2013-08-30T10:11:28Z Re: issue with calculated dimension https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542130#M202630 <HTML><HEAD></HEAD><BODY><P>In the example I posted before, I can see both the dates are considered for each expr value when you do a mouse over.</P><P></P><P>Is it possible to post a qvw with sample data (inline loads) - I will try to work on that.</P><P></P><P>If not me, it will help others also to work on the issue.</P><P></P><P>regards,</P><P></P><P>Abey</P></BODY></HTML> Fri, 30 Aug 2013 10:43:47 GMT https://community.qlik.com/t5/QlikView/issue-with-calculated-dimension/m-p/542130#M202630 abeyphilip 2013-08-30T10:43:47Z