ability to only see up to last month results for reports

[Anonymous]

Hi,

qlikview is run for end of month in the first week of the next month.  what can I do to run reports only to show results from last month results?

Cheers

Laura

[Gysbert_Wassenaar]

Create a month field in your data model, reload and select the appropriate month after you open the document.

If that's not what you need then please give more details. A small qlikview document with example data and an explanation of what you want to do would help a lot.

[sushil353 · Accepted solution]

Hi Laura,

As suggested by gwassenaar‌ you can create a Master calendar in your data model and then use a trigger while open the document to select the latest month in the Month Field.

There could be another way which is totally depend on your scenario.. you can create a variable to have the latest month by default and use that variable in your expressions.

HTH

[nagarjuna_kotha]

Can u please elaborate with more info or else provide sample data with output as u required.

-Nagarjun

[Anonymous]

I would like to use a variable.  do I need to add the variable in all formula's then/  E.g.:-

If(Contact <> '', Count({'$Year={vCurrent_fYear}') ,EngagementType)

[Anil_Babu_Samineni]

Sushil, this scenario why do we require to create master calendar. Because, date field is there so Thai we can work simple month function, right? Would you elaborate more if you have time to reply

[sushil353]

Hi Anil,

if we have a master calendar in the model then it would be easy for us to check the data for latest month , week, or year.. no need to create these field separately ... and master calendar is one time effort and could tackle future requirements .

Thanks