topic Re: Message display in QlikView

Message display

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Message display

ajsjoshua — Tue, 17 May 2016 10:41:47 GMT

Hi,

Try this

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

Re: Message display

juleshartley — Tue, 17 May 2016 10:48:13 GMT

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

Re: Message display

Tue, 17 May 2016 10:55:00 GMT

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

Re: Message display

ajsjoshua — Tue, 17 May 2016 10:57:08 GMT

Hi,

PFA

Re: Message display

juleshartley — Tue, 17 May 2016 10:58:34 GMT

What's wrong with

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

in a table expression?

Re: Message display

Tue, 17 May 2016 11:00:24 GMT

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.

Re: Message display

juleshartley — Tue, 17 May 2016 11:02:07 GMT

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)

Re: Message display

Digvijay_Singh — Tue, 17 May 2016 11:04:38 GMT

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?

Re: Message display

Tue, 17 May 2016 11:21:24 GMT

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

Re: Message display

Digvijay_Singh — Tue, 17 May 2016 11:46:21 GMT

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

Re: Message display

Tue, 17 May 2016 11:51:24 GMT

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

Re: Message display

Digvijay_Singh — Tue, 17 May 2016 11:58:50 GMT

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

Re: Message display

Tue, 17 May 2016 12:10:37 GMT

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

Re: Message display

Tue, 17 May 2016 12:29:13 GMT

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

Re: Message display

Wed, 18 May 2016 08:39:27 GMT

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