topic Re: highlighting trends in line chart in QlikView

highlighting trends in line chart

Tue, 10 Sep 2013 10:21:03 GMT

Hi,

I have a line chart. with dimension as country for a given date.It shows me the count of records.

Is it possible to highlight portions of the graph with the steepest dips as shown in the attachment?

Regards,

Anju

Re: highlighting trends in line chart

christian77 — Tue, 10 Sep 2013 10:37:21 GMT

Well, in your 3MB pic, I see you have 2 local minimuns.

Change your graph to Lines and Bars.

You may create a new expression in a bar expression and show only a determinate point.

If(Value = max(Value), Value) or something like that.

You may have to aggregate this funcktion on the dimension or dimensions required.

To get the second max(Value), exclude from the expression the first max. It's that possible?

Good Luck.

Re: highlighting trends in line chart

Tue, 10 Sep 2013 11:24:24 GMT

Hi Christian,

Thanks for replying..

I used this expression

=if(TOTAL_COUNT=min({$}TOTAL_COUNT),dual('LOW',TOTAL_COUNT))

I want the text 'LOW' to appear over min value of TOTALCOUNT, but instead I get a continous red line

Re: highlighting trends in line chart

christian77 — Tue, 10 Sep 2013 11:59:41 GMT

Go to Object Properties.

You'll see different graphics. Chose the one showing lines and bars. In the Expressions tab, select your 2^nd expression and check bars, uncheck lines.

Set your 2^nd expression as If(sum(Value)=aggr(Max(sum(Value)),Date), sum(Value), null()) à Something like that

You’ll see a bar only in the correct date.

Re: highlighting trends in line chart

Tue, 10 Sep 2013 13:24:45 GMT

I gave this expression ..

=if((TOTAL_COUNT)=min({$}(TOTAL_COUNT)),(TOTAL_COUNT),null())

but I am getting bars in a number of places

Re: highlighting trends in line chart

Tue, 10 Sep 2013 13:28:08 GMT

I get the same result when I give

=if((TOTAL_COUNT)=aggr(min(TOTAL_COUNT),LOCAL_TIME),(TOTAL_COUNT),null())

Re: highlighting trends in line chart

christian77 — Tue, 10 Sep 2013 13:32:46 GMT

Try this way

if(sum(Value)=max(total aggr( sum(Value), DATE)),sum(Value),null()),

Re: highlighting trends in line chart

Tue, 10 Sep 2013 14:00:07 GMT

Its working .. Thank You!!

I was also able to show it country wise for drilldown in the same chart by adding the expression

=if(sum(TOTAL_COUNT)=min(total aggr( sum(TOTAL_COUNT), COUNTRY)),sum(TOTAL_COUNT),null())

I have a doubt, how does total affect the final result?

Re: highlighting trends in line chart

Tue, 10 Sep 2013 14:01:11 GMT

how do I mark an answer as the correct answer?