topic Re: Display Message when no data is selected (YTD) in QlikView

Display Message when no data is selected (YTD)

Wed, 19 Aug 2015 12:53:40 GMT

Hi all,

I have a table with an YTD (year to date) expression. This works greate.

But I want to show a message if no date is slected, because in this case the table is empty.

At the moment i use this for calculating my ytd:

sum({<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} AmountofOrder)

If no date is selected it looks like this:

In this Case I want to display the Message "Please select a Year and Month"

How could I do that?

Many Thanks for your efforts.

Philipp

Re: Display Message when no data is selected (YTD)

Wed, 19 Aug 2015 12:56:51 GMT

Go to chart general tab then write conditional expression and write the error message what you want

Re: Display Message when no data is selected (YTD)

jonathandienst — Wed, 19 Aug 2015 12:59:21 GMT

Go to the Properties | General tab and enter an expression into the conditional calculation box. Something like:

GetSelectedCount(Year) > 0 And GetSelectedCount(Month) > 0

This will cause a Calculation condition unfulfilled error to appear if there is no Year or no Month (or neither) selected. Change this error message to a more relevant one by clicking Error Messages, select Calculation condition unfulfilled and type your desired error messge.

If Year and Month are not the correct field names, change the expression above to the correct field names.

Re: Display Message when no data is selected (YTD)

Wed, 19 Aug 2015 12:59:23 GMT

Ok I understand,

but what is the condition for that, and where and how can I do that... can you please give me more details?!

Re: Display Message when no data is selected (YTD)

Anonymous — Wed, 19 Aug 2015 12:59:47 GMT

define in calculation condition like

=if((GetSelectedCount(yourryearfield) > 0) AND (GetSelectedCount(yourmonthfield) > 0),-1,0)

and Change error message for "calcualation condition unfilled" to "Please select a Year and a Month)

Re: Display Message when no data is selected (YTD)

Wed, 19 Aug 2015 13:17:52 GMT

Thank you for the help, but but somehow I do not understand it complete.

This is what I have done:

Then I wrote this:

The name of the Fields is correct, but I do not know what you mean with

Go to the Properties | General tab and enter an expression into the conditional calculation box. Something like:

This will cause a Calculation condition unfulfilled error to appear if there is no Year or no Month (or neither) selected. Change this error message to a more relevant one by clicking Error Messages, select Calculation condition unfulfilled and type your desired error messge.

Re: Display Message when no data is selected (YTD)

Wed, 19 Aug 2015 13:34:06 GMT

My Mistake...

But finally I found it.

Thank you so much!!

Re: Display Message when no data is selected (YTD)

jonathandienst — Wed, 19 Aug 2015 13:36:08 GMT

Your earlier post refers:

No, that expression must be entered in the 'Calculation Condition' box from your first screen shot.

Then enter the message that should appear when the condition is not me in the box in the second screen shot. But select the "Calculation condition unfulfilled" standard message before entering your custom message.