topic Re: Hide weekend from bar chart in QlikView

Hide weekend from bar chart

Sat, 14 Mar 2015 06:35:16 GMT

Hi All,

Can someone please tell me to hide weekends from the barchart as there is no data.

Regards

Krishna

Sat, 14 Mar 2015 06:43:20 GMT

Under Properties>Dimension> select your field click on suppress when value is Null

Sat, 14 Mar 2015 06:47:53 GMT

Hi Harsha, Thnx for the reply..but the problem is i have no data for weekdays too..my only target is to hide weekends.

I wrote a condition like if(weekday(date)='Sun',hide).. i tried 0 as well its not working ....

Sat, 14 Mar 2015 06:58:40 GMT

please tell me for which weekday data is not available & what calculation you trying to achieving after removing null weekday data ...

Try with usde of Use Isnull() ...

Sat, 14 Mar 2015 07:02:34 GMT

Hi Harshal,

PFA qvw..

Regards

Krishna !

Sat, 14 Mar 2015 07:27:23 GMT

hope you want like this please let me know..

PFA,

Sat, 14 Mar 2015 07:35:44 GMT

Thnx Harshal..this is wat exactly I wanted ...

Regards,

Krishna