Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Message display

Hey guys,

Please check the attachment. This is what I am trying to achieve. I want to be able to display a message each time the column VS has row(s)  with counts greater than 1, and the month(s) with the counts greater than one should also be displayed in the message. Here is the expression i used to get the counts in the column VS : Count ({<Abonnement = {'DM-CFV','CFB'},InvoiceTypeID = {2}>}PaidWithTax) . Please any help on how I can display a message such as "The same invoice appeared more than once in the months of Jan & Feb".

Thanks,

Simon

1 Solution

Accepted Solutions
Digvijay_Singh

See this sample - You need to replace VS with actual formula somehow, also used the formula in text box as well along with alert.

View solution in original post

15 Replies
ajsjoshua
Specialist
Specialist

Hi,

Try this

=If(GetPossibleCount(VS)>1,'The same invoice appeared more than once in the months of Jan & Feb','')

juleshartley
Specialist
Specialist

I find that 'GetPossibleCount' is usually better than GetSelectedCount as it doesn't rely on a selection being made...

Not applicable
Author

Hi Guys,

I tried both but it did not work. The VS is just a label name so any other ideas.Because when I write the statement its showing errors

ajsjoshua
Specialist
Specialist

Hi,

PFA

juleshartley
Specialist
Specialist

What's wrong with

'if(Count ({<Abonnement = {'DM-CFV','CFB'},InvoiceTypeID = {2}>}PaidWithTax)>1, 'MESSAGE')

in a table expression?

Not applicable
Author

Hi Joshua,

I tried it and it did not work. The VS is just a label name so if I apply the statement as u suggested, it shows error in expression. 

juleshartley
Specialist
Specialist

If you want just a single message box outside of the table then you'll need an aggr expression on the show condition, something like:

If(

Max(

  Aggr(

   Count ({<Abonnement = {'DM-CFV','CFB'},InvoiceTypeID = {2}>}PaidWithTax)

, Maand, Factuurtype

)

)>1,1,0)

Digvijay_Singh

It looks like you want one single message showing all months having VS>1. Its tricky but where do you want to see the message, in text box or as an alert?

Not applicable
Author

Hi Singh,

As an alert please any help will be great

From: Digvijay Singh <qcwebmaster@qlikview.com>

To: Simon Bokwe <simogdee@yahoo.com>

Sent: Tuesday, May 17, 2016 1:05 PM

Subject: Re: - Message display

|

|

Message display

reply from Digvijay Singh in New to QlikView - View the full discussionIt looks like you want one single message showing all months having VS>1. Its tricky but where do you want to see the message, in text box or as an alert?

Reply to this message by replying to this email, or go to the message on Qlik Community

| Start a new discussion in New to QlikView by email or at Qlik Community

Following Message display in these streams: Inbox

© 1993-2016 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA