Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
Try this way
if(sum(Value)=max(total aggr( sum(Value), DATE)),sum(Value),null()),
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?
Thanks for replying..
I used this expression
I want the text 'LOW' to appear over min value of TOTALCOUNT, but instead I get a continous red line
Go to Object Properties.
You'll see different graphics. Chose the one showing lines and bars. In the Expressions tab, select your 2nd expression and check bars, uncheck lines.
You’ll see a bar only in the correct date.
I gave this expression ..
but I am getting bars in a number of places
I get the same result when I give
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?
how do I mark an answer as the correct answer?