topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Fri, 06 Feb 2015 02:55:12 GMT

Hi All,

I have report i want show previous date.. by default today()-1..

Actually i am using my Expression =Sum({$<Date={$(=max(Date)-1)}>}SALES)

I want to show max of the date......

but we sat and sun holiday..

when i am open on Monday this application.. i want to show Friday data...

Please anyone can help me..???

EX:

ID, Date, Sales

200,02/Feb/2015,250

300,03/Feb/2015,235

400,04/Feb/2015,190

500,05/Feb/2015,200

600, 06/Feb/2015, 200

700, 09/Feb/2015, 200

Here max date 09/Feb/2015, i have written max(date)-1, it will written 08/Feb/2015 data...

i don't want to display 8th data, i want show 6th,Feb data

Thanks in Advance.................

Re: Need Help??

jagan — Fri, 06 Feb 2015 03:22:26 GMT

Hi,

Try this

=Sum({$<Date={'$(=FirstWorkDate(Date(max(Date)-1), 1))'}>}SALES)

Hope this helps you.

Regards,

jagan.

Re: Need Help??

sunny_talwar — Fri, 06 Feb 2015 03:25:08 GMT

Update: App Attached

Does this serve your purpose?

Expression: =If(WeekDay(Max(Date)-1) = 'Sun', Sum({$<Date={'$(vMax-3Date)'}>}Sales), Sum({$<Date={'$(vMax-1Date)'}>}Sales))

Where vMax-3Date =Date(max(Date)-3) and vMax-1Date = Date(max(Date)-1)

Best,

Re: Need Help??

paulwalker — Fri, 06 Feb 2015 03:34:37 GMT

Hi jagan,

if i am using max(date)-1 it's perfect all right,

Friday=Thursday data

Thursday=Wednesday data

Wednesday=Tuesday data

Tuesday=Monday data

But here Monday=i want to show Friday' s data (Because Saturday and Sunday week-off)

By default max(date)-1, suppose maximum date Monday i want to show Friday' s data

Friday=Thursday data

Thursday=Wednesday data

Wednesday=Tuesday data

Tuesday=Monday Data

Re: Need Help??

jagan — Fri, 06 Feb 2015 04:01:24 GMT

Hi,

Try this, this is working for me as expected

=Sum({$<Date={'$(=FirstWorkDate(max(date)+ 1, 1))'}>}SALES)

For Monday this will give Friday.

Regards,

Jagan