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]

Hi Digvijay,

Please is it possible to set alerts and send emails with Qlikview Personal Edition?

[Digvijay_Singh]

Pl Check this post, may help -

CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW.docx

[#4]

Thanks,

But my question is; is it possible to do these when you have a Qlikview Personal Edition? not a Desktop Licence Edition.

[Digvijay_Singh]

I think it should be possible as there is no restriction, you need to have

smtp setup in your machine, can u try , you would come to know or else pl

create new discussion so other expert can help.

Thanks and Regards,

Digvijay Singh

[#6]

Thanks

[Anil_Babu_Samineni]

Yes, It's possible

PFA for reference

[#8]

Hi Digvijay,

Please I need some help.

Period Start

01-01-2016

01-02-2016

01-03-2016

01-04-2016

01-05-2016

01-06-2016

01-07-2016

01-08-2016

01-09-2016

01-10-2016

01-11-2016

01-12-2016

So based on these table I want to be able to create a week number field. So that when I click on the month March, I should see weeks 9,10,11,12 and if I click April I should see 13,14,15,16. Please can you help me with these please.

[Digvijay_Singh]

You need to use calendar for the same, see the attached sample -

[#10]

Hi ,

I try the sample you sent. The month of March is suppose to be 9,10,11,12 but in the sample it shows 10,11,12,13,14.

[Digvijay_Singh]

The week number generated are based on Qlikview functions, I haven't made any change in default behaviour.  I added table of data, Please suggest if you need diff behaviour. You may like to go through below HIC blog to understand new functions introduced in QV12 in this regard.

Redefining the Week Numbers

Calendars