topic Re: Variables in QlikView

Variables

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

Hi,

We required an variable which would be Monthstart to till date.

Thanks..

tresB — Thu, 20 Oct 2016 05:52:31 GMT

May be like:

vMTD = Sum({<Date={'>=$(=MonthStart(Max(Date))) <=$(=Date(Max(Date)))'}>}Sales)

shraddha_g — Thu, 20 Oct 2016 05:53:39 GMT

You can try this if you want to use it in set analysis.

set vVariable = '>=$(=date(max(MonthStart))) <=$(=date(today()))';

and use this variable in set analysis.

sum({<Date = {"$(vVariable)"}>}Field)

I hope it is helpful.

prabiradhikary — Thu, 20 Oct 2016 06:03:31 GMT

If you use this in expression :

Set Variable :

variable1 = MonthStart(variable2 )

variable2 = date(Max([Date]),'DD/MM/YYYY')

Expression :

Sum({<DATE={'>=$(variable1 )<=$(variable2)'}>} [MeasureName])

Anonymous — Thu, 20 Oct 2016 06:05:57 GMT

You can take VMTD= date(today(),'YYYY-MM').

Thanks,

nareshthavidishetty — Thu, 20 Oct 2016 06:59:57 GMT

Hi,

Sorry i need variable starts from September to till date.

Thanks..

shraddha_g — Thu, 20 Oct 2016 07:04:14 GMT

will it always be September or Previous Month Start?

prabiradhikary — Thu, 20 Oct 2016 07:06:31 GMT

You can change your variable1 as required.

maxgro — Thu, 20 Oct 2016 07:24:57 GMT

I think you can use tresesco‌ answer, with some small changes

Sum({<Date={'>=$(=MonthStart(makedate(2016,9))) <=$(=Date(today()))'}>} Sales)

or this

Sum({<Date={'>=$(=MonthStart(addmonths(today(),-1))) <=$(=Date(today()))'}>} Sales)