Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lauracastagna
Creator II
Creator II

ability to only see up to last month results for reports

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

1 Solution

Accepted Solutions
sushil353
Master II
Master II

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

View solution in original post

6 Replies
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.


talk is cheap, supply exceeds demand
sushil353
Master II
Master II

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

View solution in original post

nagarjuna_kotha
Partner
Partner

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

-Nagarjun

lauracastagna
Creator II
Creator II

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sushil353
Master II
Master II

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