topic Re: Display message per selection in QlikView

Display message per selection

Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

From the table below the goal is to have sales every month for all the shops shown on the right. But if for example when selecting a shop in this case Hilltop 58 and there are months without any sales as in the case of Mar, Jun, Oct and Dec, then a message should be displayed saying " There were no sales in the months of Mar, Jun, Oct and Dec for Hilltop 58".

Please any help on how to achieve these will be great.

Month Sales

Jan € 2,500,25

Feb € 1,252,00

Mar

Apr € 500.25

May € 3,500,95

Jun

Jul € 4,652,85

Aug € 10,458,87 SHOPS

Sep € 15,896,45 Hilltop 58

Oct T- Square 45

Nov € 25,875,65 Spring bell 38

Dec Down beach 10

Coastal city 5

Thanks in advance.

Re: Display message per selection

sushil353 — Thu, 23 Jun 2016 08:10:28 GMT

Hi,

You can try below expression in text box.

='There were no sales in the months of '&Concat({<Sales={''}>}Month,',')&GetFieldSelections([SHOPS])

HTH

Sushil

Re: Display message per selection

Anil_Babu_Samineni — Thu, 23 Jun 2016 08:22:12 GMT

Simon,

If possible, Can you please share me the Application?

So that we can apply directly on your App only..

- Anil

Re: Display message per selection

varshavig12 — Thu, 23 Jun 2016 08:28:58 GMT

Expression in Straight table:

if(sum(Sales)=null(),

'There were no sales in the months for '&GetFieldSelections(Shops),

sum(Sale_Amount))

Re: Display message per selection

varshavig12 — Thu, 23 Jun 2016 08:29:48 GMT

You want this straight table or text box ?

Re: Display message per selection

Thu, 23 Jun 2016 08:31:17 GMT

Text box please

Re: Display message per selection

Anil_Babu_Samineni — Thu, 23 Jun 2016 08:31:36 GMT

Varsha,

Share me your qvw with Selection popup

- Anil

Re: Display message per selection

varshavig12 — Thu, 23 Jun 2016 08:33:53 GMT

Hi Anil,

I dont have any sample for this.

Ask Simon.

Re: Display message per selection

Thu, 23 Jun 2016 08:40:00 GMT

The app contain sensitive info from clients. But from the sample I posted could you help?

Re: Display message per selection

Thu, 23 Jun 2016 08:40:42 GMT

Varsha

Thanks for the suggestion I will try these and see if it works

Re: Display message per selection

Thu, 23 Jun 2016 08:48:54 GMT

Thanks Sushil,

I will try to apply it and see if it works

Re: Display message per selection

varshavig12 — Thu, 23 Jun 2016 08:54:06 GMT

Hi Simon,

sushil353‌ solution is working properly.

Re: Display message per selection

Thu, 23 Jun 2016 09:05:11 GMT

Varsha I tried it in a sample qvw but the months with no sales don't appear on the table

Re: Display message per selection

Digvijay_Singh — Thu, 23 Jun 2016 09:19:36 GMT

Try this -

Re: Display message per selection

varshavig12 — Thu, 23 Jun 2016 09:20:20 GMT

You want it in text box, Right ?

Why are you searching it in table ?

Re: Display message per selection

Thu, 23 Jun 2016 09:25:54 GMT

Thanks Digvijay,

Please how did you get display the months with no sales in the table as well? Because I also did sum(sales) but months with no sales did not appear.

Re: Display message per selection

Digvijay_Singh — Thu, 23 Jun 2016 09:29:15 GMT

Match these in Dim and Present tabs -

Re: Display message per selection

Digvijay_Singh — Thu, 23 Jun 2016 09:32:00 GMT

I also used sort weight Sno field to sort the months. Created inline table with month,Sno fields. This helps to show months in a sequence when using concat. Couldn't think of any other method as of now.

Re: Display message per selection

Thu, 23 Jun 2016 09:37:41 GMT

Were do I find the "sort weight Sno field"? to sort the month. I just did what you said but now all months with zero values appear together

Re: Display message per selection

Digvijay_Singh — Thu, 23 Jun 2016 09:45:02 GMT

You may need to adapt it based on your data, mine one is just a sample -

SNo is created In the script as below -

Month:

Load * inline [

Month,SNo

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12 ];