topic Re: Trend in Straight Table in QlikView

Trend in Straight Table

Anonymous — Fri, 30 Sep 2016 18:29:43 GMT

I have 2 straight tables , in one I was able to display trend and the other I cannot .. not sure what the issue is .. can someone please take a look .. I want the trend of Total Exception by Query date .. the line does not appears only the MAX values are marked

Thanks!

Re: Trend in Straight Table

rupamjyotidas — Fri, 30 Sep 2016 19:03:37 GMT

When you make a Table with Query Date, the Mini chart with dimension Query Date will show just one value, as the table you have column with Query Date.

To display trend you need multiple values across the dates.

Re: Trend in Straight Table

rupamjyotidas — Fri, 30 Sep 2016 19:19:51 GMT

When you put the trend for the 3 dates in pivot table with Dimension:Query Date already present(Query Date,Group,Count), it will plot just one dot for each day.

Probably if you year in dimension instead of Query Date, mini chart will work

Yeah,,Group,Count for this the mini chart will work

Query Date,Group, Count: Mini chart will show one dot as you are breaking the dates apart.

Re: Trend in Straight Table

rupamjyotidas — Fri, 30 Sep 2016 19:23:26 GMT

This will work

Re: Trend in Straight Table

Anonymous — Fri, 30 Sep 2016 19:23:49 GMT

But I am ignoring Query Date in the expression , attached the app again .. I actually tried ignoring all the fields given in dimension also but it did not work

Re: Trend in Straight Table

rupamjyotidas — Fri, 30 Sep 2016 19:57:42 GMT

Add date in Equation

Remove Query Date from Dimension .

Re: Trend in Straight Table

Anonymous — Fri, 30 Sep 2016 19:59:39 GMT

Oh I think you have added a wrong field the field I wanted is Query Date and if I add that this is how it looks

Re: Trend in Straight Table

rupamjyotidas — Fri, 30 Sep 2016 20:06:50 GMT

I am sorry but if you put 'Query Date' in 'chart dimension' and 'Query Date' also in 'Mini Chart Dimension', Your mini chart won't work.

Re: Trend in Straight Table

Anonymous — Fri, 30 Sep 2016 21:07:27 GMT

Can someone confirm that there is no way I could show Query Date in the table along with trend.

Re: Trend in Straight Table

Frank_Hartmann — Sun, 02 Oct 2016 10:28:32 GMT

If you connect your "QueryDate" field to a mastercalendar you will be able to show your expected output!

See attached qvw

Hope this helps!

Re: Trend in Straight Table

Anonymous — Tue, 04 Oct 2016 17:45:59 GMT

Can someone please take a look at the attached document .. I did the same thing but the trend does not appear

Re: Trend in Straight Table

Frank_Hartmann — Wed, 05 Oct 2016 09:49:25 GMT

see attached

hope this helps !

Re: Trend in Straight Table

Anonymous — Thu, 06 Oct 2016 07:06:23 GMT

Please find the attached 2 documents .. one with solution worked and one without . please take a look at both the data models .. the Actual Document has lot more tables and Test document just had data related to exceptions , though exceptions data is not related to rest of the data model the charts behave different in both the documents .. unable to figure out the reason behind this ..

Any help on getting this resolved please ?

Re: Trend in Straight Table

Anonymous — Thu, 06 Oct 2016 17:37:42 GMT

swuehl‌

Can you please help me with this ... all I am looking is trend based of a query date for total exception , its total exceptions over time.