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.
So you don't have any sample to guide me on how I can go about it?
From: Digvijay Singh <qcwebmaster@qlikview.com>
To: Simon Bokwe <simogdee@yahoo.com>
Sent: Tuesday, May 17, 2016 1:47 PM
Subject: Re: - Message display
|
|
|
|
Message display
reply from Digvijay Singh in New to QlikView - View the full discussionSee this sample - You need to replace VS with actual formula somehow, also used the formula in text box as well along with 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
Don't understand what do you mean, could you see the sample attached?
Hey Singh,
Sorry I see the attachement now.
Thanks let me try to see if it will work out
From: Digvijay Singh <qcwebmaster@qlikview.com>
To: Simon Bokwe <simogdee@yahoo.com>
Sent: Tuesday, May 17, 2016 1:59 PM
Subject: Re: - Message display
|
|
|
|
Message display
reply from Digvijay Singh in New to QlikView - View the full discussionDon't understand what do you mean, could you see the sample attached?
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
Hey Singh,
Your solution kinda work but I don't know how to change the VS into a formular and then use it in the text box. Please any help?
From: Digvijay Singh <qcwebmaster@qlikview.com>
To: Simon Bokwe <simogdee@yahoo.com>
Sent: Tuesday, May 17, 2016 1:59 PM
Subject: Re: - Message display
|
|
|
|
Message display
reply from Digvijay Singh in New to QlikView - View the full discussionDon't understand what do you mean, could you see the sample attached?
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
Hey Singh,
Please I still have not figure out how to change VS into a formular. Still waiting if you can help me out.
Thanks,Simon