topic Re: set analysis in QlikView

set analysis

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

My expression is sum(sales) but i need to modify that as sum(sales) from vYesterday to vPast varisbles.

Thanks..

sunny_talwar — Tue, 21 Feb 2017 17:44:57 GMT

Can you provide more information? What is vYesterday? What is your date field? It's format... etc etc

nareshthavidishetty — Tue, 21 Feb 2017 17:50:37 GMT

HI ,

Please find below.

vYsterday = date(today()-1,'M/D/YYYY');

vPast = date(today()-28,'M/D/YYYY');

Where Date=Today

Thanks..

Anonymous — Tue, 21 Feb 2017 17:55:37 GMT

Sum({$<Date={'>=$(=Date(vPast, 'M/D/YYYY'))<=$(=Date(vYsterday, 'M/D/YYYY'))'}>} Sales)

nareshthavidishetty — Tue, 21 Feb 2017 18:01:56 GMT

Hi,

It's not working..

Thanks..

Anonymous — Tue, 21 Feb 2017 18:11:33 GMT

what is date field name ?

nareshthavidishetty — Tue, 21 Feb 2017 18:24:50 GMT

Field Name =Date

Thanks..

Anonymous — Tue, 21 Feb 2017 18:40:49 GMT

Sum({<Date = {">=$(=Date(Today()-28,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"} } Sales)

Sum({<Date = {">=$(=Date(Today()-28,'M/DD/YYYY'))<=$(=Date(Today()-1,'M/DD/YYYY'))"} } Sales)

I have doubt on your "Date" field format ...