topic Re: Help me in displaying the data on barchart? in QlikView https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930975#M321843 <HTML><HEAD></HEAD><BODY><P>Created a variable:</P><P><EM>vTenthDATE=Max(DATE,10)</EM></P><P>Then in the <STRONG>group</STRONG>, edited the DATE field to expression: <EM>=If(DATE&gt;=vTenthDATE, DATE)</EM></P></BODY></HTML> Fri, 11 Sep 2015 05:21:27 GMT tresB 2015-09-11T05:21:27Z Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930966#M321834 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>Help me in displaying the latest 10 dates and values in chart?</P><P></P><P>Please find the attached application.</P><P></P><P>Thanks,</P><P>Durga</P></BODY></HTML> Fri, 11 Sep 2015 04:56:37 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930966#M321834 durgabhavani 2015-09-11T04:56:37Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930967#M321835 <HTML><HEAD></HEAD><BODY><P>Hi Durga,</P><P></P><P>Is there anyway you can share the data in your qvw file? I am working with Personal Edition of QlikView and won't be able to share what you have shared?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 11 Sep 2015 04:59:08 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930967#M321835 sunny_talwar 2015-09-11T04:59:08Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930968#M321836 <HTML><HEAD></HEAD><BODY><P>PFA&nbsp; and setting.</P><P></P><P>Vikas</P></BODY></HTML> Fri, 11 Sep 2015 05:02:24 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930968#M321836 vikasmahajan 2015-09-11T05:02:24Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930969#M321837 <HTML><HEAD></HEAD><BODY><P>sunny please find the attachment.</P></BODY></HTML> Fri, 11 Sep 2015 05:09:00 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930969#M321837 durgabhavani 2015-09-11T05:09:00Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930970#M321838 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Fri, 11 Sep 2015 05:09:50 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930970#M321838 tresB 2015-09-11T05:09:50Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930971#M321839 <HTML><HEAD></HEAD><BODY><P>Vikas,</P><P></P><P>I dont want to display other values apart from 10 latest dates on chart.</P><P></P><P>please advice</P></BODY></HTML> Fri, 11 Sep 2015 05:09:51 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930971#M321839 durgabhavani 2015-09-11T05:09:51Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930972#M321840 <HTML><HEAD></HEAD><BODY><P>you mean to say top 10 values ???</P></BODY></HTML> Fri, 11 Sep 2015 05:14:11 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930972#M321840 vikasmahajan 2015-09-11T05:14:11Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930973#M321841 <HTML><HEAD></HEAD><BODY><P>tres, what changes you made to app</P></BODY></HTML> Fri, 11 Sep 2015 05:16:37 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930973#M321841 durgabhavani 2015-09-11T05:16:37Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930974#M321842 <HTML><HEAD></HEAD><BODY><P>No Vikas, Latest 10 dates from today to back.</P></BODY></HTML> Fri, 11 Sep 2015 05:20:33 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930974#M321842 durgabhavani 2015-09-11T05:20:33Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930975#M321843 <HTML><HEAD></HEAD><BODY><P>Created a variable:</P><P><EM>vTenthDATE=Max(DATE,10)</EM></P><P>Then in the <STRONG>group</STRONG>, edited the DATE field to expression: <EM>=If(DATE&gt;=vTenthDATE, DATE)</EM></P></BODY></HTML> Fri, 11 Sep 2015 05:21:27 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930975#M321843 tresB 2015-09-11T05:21:27Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930976#M321844 <HTML><HEAD></HEAD><BODY><P>You can simply use the "Dimension Limits" tab on the properties of the chart and select "Date" and select "Restrict which values are displayed using the first expression" and have "Show Only" largest 10 Values - which means:</P><P></P><P>Largest 10 values for Date translates into The Last 10 Dates...</P><P></P><P><IMG alt="2015-09-11 #1.PNG" class="jive-image image-1" src="/legacyfs/online/98584_2015-09-11 #1.PNG" style="height: 238px; width: 620px;" /></P></BODY></HTML> Fri, 11 Sep 2015 05:42:37 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930976#M321844 petter 2015-09-11T05:42:37Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930977#M321845 <HTML><HEAD></HEAD><BODY><P>Tres,</P><P></P><P>it is working but when clicking on the bar it is not showing the data. throws error no data to display.</P><P></P><P>it need to drill down when i am clicking bar in bar chart.</P><P></P><P>Petter,</P><P></P><P>i want show the last (latest) 10 dates what ever the data (may be largest or smallest) but not largest values.</P><P></P><P>Please advice.</P><P></P><P>Thanks</P><P>Durga</P></BODY></HTML> Fri, 11 Sep 2015 06:02:21 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930977#M321845 durgabhavani 2015-09-11T06:02:21Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930978#M321846 <HTML><HEAD></HEAD><BODY><P>It actually is the same - it is the largest values of the dimension Date. The "largest" 10 dates are the last 10 dates ... it is not the largest 10 values of the expression.</P><P></P><P>Study it closely and you should see that it is correct I think <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Sep 2015 06:08:38 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930978#M321846 petter 2015-09-11T06:08:38Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930979#M321847 <HTML><HEAD></HEAD><BODY><P>A date can't have multiple weeks, so there is nothing to further drill down from your group. Could you explain your expected drill behaviour?</P></BODY></HTML> Fri, 11 Sep 2015 06:10:42 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930979#M321847 tresB 2015-09-11T06:10:42Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930980#M321848 <HTML><HEAD></HEAD><BODY><P>tres,</P><P></P><P>I am talking about drill down of bar in barchart. click on first bar in barchart, you know the issue.</P><P></P><P>modified app attached.</P></BODY></HTML> Fri, 11 Sep 2015 07:01:05 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930980#M321848 durgabhavani 2015-09-11T07:01:05Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930981#M321849 <HTML><HEAD></HEAD><BODY><P>Uncheck 'Supress When Value is Null' in dimension tab. Is this behaviour okay? <EM>QlikView doesn't drill to a further level where there is <STRONG>single value </STRONG>(as the case here with your case; from DATE to a Week; a DATE can have only single value).</EM></P></BODY></HTML> Fri, 11 Sep 2015 07:07:44 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930981#M321849 tresB 2015-09-11T07:07:44Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930982#M321850 <HTML><HEAD></HEAD><BODY><P>Tres,</P><P>After unchecking the supress when values is null, it drill downs but it not showing the date under bar?</P><P></P><P>why it happens.</P><P></P><P><BR /> </P></BODY></HTML> Fri, 11 Sep 2015 07:38:28 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930982#M321850 durgabhavani 2015-09-11T07:38:28Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930983#M321851 <HTML><HEAD></HEAD><BODY><P><IMG alt="null values.JPG" class="jive-image image-1" src="/legacyfs/online/98613_null values.JPG" style="width: 620px; height: 156px;" /></P></BODY></HTML> Fri, 11 Sep 2015 07:41:49 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930983#M321851 durgabhavani 2015-09-11T07:41:49Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930984#M321852 <HTML><HEAD></HEAD><BODY><P>It is not giving latest 10 dates, it is missing some dates with lowest values.</P></BODY></HTML> Fri, 11 Sep 2015 07:42:58 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930984#M321852 durgabhavani 2015-09-11T07:42:58Z Re: Help me in displaying the data on barchart? https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930985#M321853 <HTML><HEAD></HEAD><BODY><P>tres,</P><P></P><P>it need to drill down on that date upto trigger ID level. ex( IT5 and IT4).</P><P></P><P>please advice</P></BODY></HTML> Fri, 11 Sep 2015 07:46:09 GMT https://community.qlik.com/t5/QlikView/Help-me-in-displaying-the-data-on-barchart/m-p/930985#M321853 durgabhavani 2015-09-11T07:46:09Z