Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max and Min Values on Data points

Hi All,

I have a querry.i am using a line chart with product and the below expression for month as dimension

and i am using sum(volume) as expression.

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week), Week)


By using this expression the dimension label will be month were as the data points will be for weeks.as below graph.

Capture.PNG

here in the above graph,for each month you can see 4 or 5 data points ie. for each weeks.


Now i want to show values on data points only for the max week and the min week. Any idea how it can be achieved.


Regards,

Reena

10 Replies
Not applicable
Author

Thanks a lot Jyothish...it worked for me..