topic Re: month end Vs rolling weeks in QlikView

month end Vs rolling weeks

Nagaraju_KCS — Mon, 27 Nov 2017 23:23:51 GMT

Hi Community,

I have 2 tabs one for Revenue and second for Weekly data..

Revenue tab: I have to show month list box January to October. (data should have associate Jan to Oct only)

this sheets effects Monthly once....

Weekly Tab: Rolling weeks, have to show Current Month as well. (January to November and associate data Jan to Nov)

this sheet effects weekly reload.

how to manage Month End Process Vs Rolling weeks, please can you suggest?

Thanks in Advance.......

Re: month end Vs rolling weeks

Anil_Babu_Samineni — Tue, 28 Nov 2017 02:06:48 GMT

Suggest to create MonthNum field in script using Number format to show number seq in Months

Num(Month(TempDate)) as Month_Num,

And then, It could be use this?

Sum({<Month_Num = {"<$(=Num(Month(Today())))"}>} Sales)

Sum({<Month_Num = {"<$(=Num(Month(Today())))"}>} Amount)

And same for Weekly report

Sum({<Month_Num = {"<=$(=Num(Month(Today())))"}>} Sales)

Sum({<Month_Num = {"<=$(=Num(Month(Today())))"}>} Amount)

Re: month end Vs rolling weeks

Nagaraju_KCS — Tue, 28 Nov 2017 08:22:39 GMT

Thanks for reply,

Actually i have many expressions, i can't change expression wise..

any possibility to set trigger level...??

If i create two calendar's will it work ??

Re: month end Vs rolling weeks

Anil_Babu_Samineni — Tue, 28 Nov 2017 08:24:09 GMT

Trigger with sheet?? Or simple trigger for all sheets?

Re: month end Vs rolling weeks

Nagaraju_KCS — Tue, 28 Nov 2017 08:27:08 GMT

sheet wise trigger

Re: month end Vs rolling weeks

Anil_Babu_Samineni — Tue, 28 Nov 2017 08:35:49 GMT

give it a shot, Because i don't have access to your file now due to client space

Anyway, Try this way

Create OnOpen Trigger and use Activate Sheet to First sheet object and use same as Further to add select using Month_Num as FieldName and string should be ='<' & Num(Month(Today()))

Same manner, Give it a shot as Sheet Activate from sheet level with same as action "Select in Field" to Month_Num as field name and String should be ='<=' & Num(Month(Today()))