topic Re: Variable in QlikView

Variable

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

Hi,

I need to create an dynamic variable which need to show sum(data) for only 1st of every month which would starts from FEB 2016.

Like sum(sales) where date = 03/01/2016(Mar),04/01/2016(Apr),......

Thanks..

Gysbert_Wassenaar — Fri, 02 Dec 2016 13:25:18 GMT

Perhaps like this: sum({<date={"=Day(date)=1"}>}sales)

nareshthavidishetty — Fri, 02 Dec 2016 14:32:14 GMT

Hi,

I have used the below logic but it is giving value.But here i need for all the months where yearstart = Feb 2016.

sum({<[Reported Date]={"=Day([Reported Date])=1"}>}[Invoice Total Line Amt])

Thanks..

vishsaggi — Fri, 02 Dec 2016 14:46:52 GMT

Can you send us the screen shot of your expected output.? Or issue you are having. Gysbert's expression should give you the 1st of every month.

nareshthavidishetty — Fri, 02 Dec 2016 16:35:52 GMT

Hi Gysbert,

Can i have the same logic instead of month start to month end.

Thanks..

sunny_talwar — Fri, 02 Dec 2016 16:41:49 GMT

Something like this:

Sum({<[Reported Date] = {"=Day([Reported Date])=Day(MonthEnd([Reported Date]))"}>} [Invoice Total Line Amt])

Gysbert_Wassenaar — Fri, 02 Dec 2016 17:03:41 GMT

What logic? What do you mean 'month start to month end'? Which month for example?