topic Re: prior day vs today in QlikView

prior day vs today

Wed, 25 Nov 2020 16:16:04 GMT

hi team

I'm having data as of july 2016 month. I need to create the comparision for today & yesterday. could some one help me out

krishnacbe — Tue, 06 Sep 2016 19:42:58 GMT

Hi,

Can you explain your requirement in details or share the input data and output format to help on this.

Tue, 06 Sep 2016 19:56:41 GMT

I'm having data as of 7th month. I need to calculate the yesterday & today varience

krishnacbe — Tue, 06 Sep 2016 20:45:38 GMT

You can calculate the expression with Set modifier having Today() and Today()-1 and then find the variance between them.

Still if you add some input data it will help to resolve the issue.

Jason_Michaelides — Tue, 06 Sep 2016 21:01:57 GMT

saimahasan — Wed, 07 Sep 2016 05:24:35 GMT

Please post sample data so that much accurate solution can be provided.

Wed, 07 Sep 2016 13:47:31 GMT

Thank you Jason

Wed, 07 Sep 2016 13:47:59 GMT

Thank you Krishnapiya

Wed, 07 Sep 2016 14:37:22 GMT

Hi,

You will find infinite threads doing the comparisons based on Date using set analysis or alternate states.

check this out:

Hope this helps.

Thanks,

Singh

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:03:02 GMT

How about this

Today = Max(Date)

Previous = (Max(Date)-1)

Sum({$<Date = {"$Today) - $(Previous)"}>}Sales)