topic Re: Message with no expressions in QlikView

Message with no expressions

clovati — Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

In a PIVOT TABLE I choose one (QTY) or another (EUROS) set of expression by 2 buttons. When both of them are not choosen I hide both set of expressions. How can I give a message like for example 'Please choose QTY or EUROS' ? I want to preserve dimensions then I wouldn't use textbox with the message.thank you all and have a good sunday!

Re: Message with no expressions

Anil_Babu_Samineni — Sun, 28 May 2017 05:59:33 GMT

Go to Properties - General - Error Messages - Calculation Condition Unfulfilled. Here you need declare the the message like "Please Choose QTY or EUROS"

And then, General - You have to write the condition from Calculation Condition like

GerSelectedCount(QTY) > 0 or GetSelectedCount(EUROS)>0

Re: Message with no expressions

avinashelite — Sun, 28 May 2017 06:40:08 GMT

Two ways to achieve this

1.Hide/show your chart from the layout condition > with the condition GerSelectedCount(QTY) > 0 or GetSelectedCount(EUROS)>0 and show the a text box with the msg you want

2.Follow the approach as Anil mentioned

Re: Message with no expressions

Digvijay_Singh — Sun, 28 May 2017 07:52:50 GMT

I think you need something like attached. You can achieve this with the help of two variables and set them accordingly with different event along with message at the top.