Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys, I hope you can help me
I have 3DIM: 1. Country, 2.FMonth, 3.FYear.
I want to show all Values from FMonth (checked, and also supress zero)
Now it shows the values in separated Years with selected and with "-" where the NULL values are..
Is it possible to combine the NULL/Zero-Values in 1 Year ?
I have also tested with "show all values " for Fyear(3. DIM), but it only shows every year that I've got in my Database..
Best regards,
Tob
No no,
I want like this
But, the zeros should be in 2014.. not separeted..
It doenst work..
i also tried
if(Month(IsNull(sum(EURamount))),0.1,sum(EURamount))
ok.. then you have to work on data modelling itself.
you have to create "0" in month field and it has to be mapped with norelated datas.
If you are not understanding please attach the application here
-Sathish
right, but how can I express this in my script?
I have also other Types like Region, Customer, Salesperson ...
How can I tell Qlikview to show 0 for every Dimension if its not a value ?
Did you tried :
In your graphic Propriety box, sheet Dimension, stick ‘Shows Al value”
yes, but it shows chart in separated years: "2014" and "-"
is it possible to post your .qvw ?
Its very easy only.. attach your application or attach your data modelling.
-Sathish