Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this sample - You need to replace VS with actual formula somehow, also used the formula in text box as well along with alert.
Hi,
Try this
=If(GetPossibleCount(VS)>1,'The same invoice appeared more than once in the months of Jan & Feb','')
I find that 'GetPossibleCount' is usually better than GetSelectedCount as it doesn't rely on a selection being made...
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
Hi,
PFA
What's wrong with
'if(Count ({<Abonnement = {'DM-CFV','CFB'},InvoiceTypeID = {2}>}PaidWithTax)>1, 'MESSAGE')
in a table expression?
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.
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)
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?
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