Solved: Re: Display message per selection - Page 12 - Qlik Community

Report Inappropriate Content · ‎2016-06-23

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.

Digvijay_Singh · ‎2016-08-16

Check and let me know which week you feel is not rightly mentioned.

Digvijay_Singh · ‎2016-08-16

If I set broken week variable to 0, it starts new week from 4th Jan as below, and then march starts from 9th week -

Report Inappropriate Content · ‎2016-08-17

Hey Digvijay,

Please I need some help.

Customer Date Vol1 Vol2

ChatterTech 01-03-16 15,550 16,350

ChatterTech 02-03-16 20,632 21,369

-----------------------------------------------------------------

ChatterTech 30-04-16 18,632 19,369

Based on these sample table I have these customer's information from the 1st of March to the 30 of April 2016. So I created a calendar based on the field Date and I wanted to analyse the data based on Week number. For the two months I expect to see the week numbers from 9,10,11,12,13,14,15, and 16. But instead I am seeing week numbers from 10 through to 18 without week 9 even. So please any help on how to get these done. My desired results is if I click on March, I should see week 9,10,11 and 12. And if its April, I should see week 13,14,15 and 16. Since logically January has week 1 to 4 and February week 5 to 8.

Thanks

Report Inappropriate Content · ‎2016-08-17

Hi Digvijay,

I just saw the messages you sent me yesterday. I tried it as you suggested and it worked. But I can still see week 17 in the month of April . I guess that is how it is for the year 2016. Or is there something you can do to change that. Because part week 9 is also in February.

Thanks

Digvijay_Singh · ‎2016-08-17

a Week start from every Monday and continues for next 7 days, it doesn't break on month ends, this is the way Qlikview date functions work and international standards follow the same. If you want your week number to start fresh from first day of every month then you need to define new numeric field but then you may not have exactly 7 days in each week.

Report Inappropriate Content · ‎2016-08-17

Hi,

Here is more help I need please.

Week Received % Values

9 576 3,296

10 672 3,348

11 668 3,676

12 672 3,412

Normally if Received is 672, it means all invoices where received. So in the % column I want to say the row below divided by the row above multiply by 100 to get the percentage. And for the Values column i want to say the maximum value should have a different color and the minimum value should also have a different color.

Thanks

Report Inappropriate Content · ‎2016-08-17

Thanks, I appreciate your explanation. I will just leave it as it is.

Digvijay_Singh · ‎2016-08-17

Something like this? Used bkground color and text color xp to change the color.

Report Inappropriate Content · ‎2016-08-17

Thanks

Report Inappropriate Content · ‎2016-09-02

Hi Digvijay,

Please I have a long list of Sales Reps and I want to assign them different percentages based on their sales performances. So, how do I achieved that without writing a long list of "If Statements". For example

if(Name = 'Simon',0.5 * (sum(Sales),

if(Name = 'Daniel',0.3 * (sum(Sales)) . Please how can a write an expression in qlikview that can help me avoid such a situation? Thanks in advance.

Simon.