topic Re: Set Analysis in QlikView

Set Analysis

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

Hi ,

Please see attached.

I am trying to get today's sales figure and the year to date sales figure in a text box, but not getting any result with the current expression.

So, if today's date is 23 Jan 2017, the figure for today's sales should be 1,000 and the year to date figure should be 314,044

Any idea where I am going wrong?

Thanks

sushil353 — Mon, 23 Jan 2017 09:23:25 GMT

Hi,

Just change your environmental variable as

SET DateFormat='DD-MMM-YY';

SET TimestampFormat='DD-MMM-YY h:mm:ss[.fff] TT';

and expression :

='$'&num(SUM({<Date={"$(=date(vDisplayDate,'DD-MMM-YY'))"}>}Sales),'#,##0','.',',')

YTD: ='$'&num(SUM({<Date={"<=$(=date(vDisplayDate,'DD-MMM-YY'))"}>}Sales),'#,##0','.',',')

HTH

Sushil

Anil_Babu_Samineni — Mon, 23 Jan 2017 09:29:43 GMT

Try to change env variables, Becuase you have DD-MMM-YY Format. But Date gave only DD-MM-YYYY

shamitshah — Mon, 23 Jan 2017 09:57:55 GMT

Thanks Sushil.

shamitshah — Mon, 23 Jan 2017 09:58:08 GMT

Thanks Anil.