Display message per selection

[#1]

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.

[sushil353]

Hi,

You can try below expression in text box.

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

HTH

Sushil

[Anil_Babu_Samineni]

Simon,

If possible, Can you please share me the Application?

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

- Anil

[varshavig12]

Expression in Straight table:

if(sum(Sales)=null(),

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

sum(Sale_Amount))

[varshavig12]

You want this straight table or text box ?

[#6]

Text box please

[Anil_Babu_Samineni]

Varsha,

Share me your qvw with Selection popup

- Anil

[varshavig12]

Hi Anil,

I dont have any sample for this.

Ask Simon.

[#9]

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

[#10]

Varsha

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