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

Announcements
Join us in Bucharest on Sept 18th 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

15 Replies
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.

Not applicable
Author

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

Digvijay_Singh

Don't understand what do you mean, could you see the sample attached?

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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