3 Replies Latest reply: May 9, 2012 7:20 AM by jonnadegerman RSS

Last Month Label & Error Message

Bill Ringer Salalima

Hi,

 

How can I put an error message like "Please select Year and Month' to viiew this report"

 

And, how can I put the Label, "last month"

 

say for example, this month is Feb 2012, then last month is Jan 2012...

 

Please help me, im using Qlikview 11. Thanks.

 

Best Regards,

Bill

  • Re: Last Month Label & Error Message
    jonnadegerman

    Hi,

     

    For an error message you can use an if statement like:

     

    if(GetSelectedCount([Year Month]) >= 1, expression, 'Please select Year and Month to View this report")

     

    And for labels you can use in the window title =max(Month) & ‘ ‘ & max(Year)

    And if you want previous month or previous year you add -1 =(max(Month)-1) & ‘ ‘ & (max(Year)-1)

    • Last Month Label & Error Message
      Bill Ringer Salalima

      Hi,

       

      can u help?

       

      Without selecting Year or Month, the chart did not display data...

       

      and this is the expression

       

      sum({$<Year = {$(=max(Year))}, MonthNum = {$(=max(MonthNum))}>}[Gross Purchase])

       

      I already tried using Month = maxString(Month)

       

      but still does not display... why? im using qlikview 11...

       

      that report is This Month data

  • Last Month Label & Error Message
    jonnadegerman

    Hi,

     

    Can you send the .qvw? Or an example of what your data looks like? The set analysis looks correct.

    When I have encountered that problem before the problem have been that my data have had more dates than I had data for. Example:

     

    Year     Month     Sales

    2012     1            20

    2012     2            30

    2012     3            40

    2012     4       

    2012     5

     

    So the max date is May 2012 in the data, but since there's no sales for that month, it won't display any data.

     

    What does the lable say for the max(month)?