topic Re: How to show less data in a Barchart ? in QlikView

How to show less data in a Barchart ?

thanstad — Fri, 04 Sep 2015 08:00:04 GMT

I have a barchart with Days on X axis but this day is calculatet on a booking date showing days in future. I would like til show max of today() on the axis. I have tried to do this in the script without, did not work. Now I have generatet a variable $(vMaxViewDay) wich i based on today(). I have tried to make a if condition combined with Set Analysis but not getting this right. Anyone who can assist me.

Tormod Hanstad

Re: How to show less data in a Barchart ?

Anonymous — Fri, 04 Sep 2015 08:04:34 GMT

Hi,

please can you share your expressions

regards

Neetha

Re: How to show less data in a Barchart ?

thanstad — Fri, 04 Sep 2015 11:28:36 GMT

if(booking_Day>$(MaxViewDay),count(Distinct{<Booking_Day={'$(vMaxViewDay)'}>}D__ADBConnected_Device_Ser_No) I now this is not working and Iam seeking a possibility to make this better.

Tormod