Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i wonder if we can "trick" QV to show a zero value even if the expression doesent return any values for a certain selection.
example, if i would make the selection of Month Selection of Januari:
SalesMan Ludwig Pettersson would Not appear, since he has no sales in Januari.
Säljare | Säljare_Kortnamn | År | Januari | Februari | Mars | April | Maj |
66 431 888kr | 10 696 026kr | 13 934 628kr | 17 190 098kr | 17 279 568kr | 7 331 568kr | ||
Staffan Lundell | STLU | 2 994 070kr | 343 648kr | 810 576kr | 724 049kr | 1 007 348kr | 108 449kr |
Stefan Lehnberg | STLE | 2 674 122kr | 320 281kr | 593 376kr | 518 382kr | 887 290kr | 354 793kr |
Andreas Löfkvist | ANLO | 2 663 713kr | 507 721kr | 725 624kr | 356 542kr | 825 711kr | 248 115kr |
Peter Carlzon | PECA | 3 580 418kr | 757 438kr | 671 960kr | 1 026 490kr | 679 310kr | 445 220kr |
Linus Jonasson | LIJO | 3 079 908kr | 673 560kr | 551 400kr | 630 081kr | 608 867kr | 616 000kr |
Ludwig Pettersson | LUPE | 1 616 414kr | 0kr | 0kr | 731 166kr | 544 124kr | 341 124kr |
Lena Åhström | LEAH | 1 238 070kr | 215 615kr | 309 135kr | 110 440kr | 531 510kr | 71 370kr |
The results after selection of Januari. I would like to see Ludwig here but with a zero value on Januari sales.
Säljare | Säljare_Kortnamn | År | Januari |
2 602 648kr | 2 602 648kr | ||
Peter Carlzon | PECA | 757 438kr | 757 438kr |
Linus Jonasson | LIJO | 673 560kr | 673 560kr |
Andreas Löfkvist | ANLO | 507 721kr | 507 721kr |
Staffan Lundell | STLU | 343 648kr | 343 648kr |
Stefan Lehnberg | STLE | 320 281kr | 320 281kr |
Thx in advance for the help.
/André
Have you tried unchecking 'Suppress Zero-Values' on the presentation tab?
Uncheck Suppress zero values in Presentation tab
I am hoping that you are using Pivot table... So give a try on the below:
In your chart properties, Go to "Presentation" tab and uncheck "Suppress Zero-Values" and this should give you the results.
I am attaching a sample here and hope this helps...
Hi
There can be a work around. First you need to create a table with customer name and months. This table should have all possible combinations of months and customer name. Now you can join your sales data. Post this , if any sales man has no sales in a particular month, then you will have a null there and you can show that on chart.
Hope that helps
Hi I attach the document, then you could try, cuz the supress zero values doesent seems to do the trick.
could you have a look?
Thx
What exactly are we working with??