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.

[#2]

Thanks Sushil,

I will try to apply it and see if it works

[varshavig12]

Hi Simon,

sushil353‌ solution is working properly.

[#4]

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

[Digvijay_Singh]

Try this -

[varshavig12]

You want it in text box, Right ?

Why are you searching it in table ?

[#7]

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.

[Digvijay_Singh]

Match these in Dim and Present tabs -

[Digvijay_Singh]

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.

[#10]

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

[Digvijay_Singh]

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 ];