Discussion Board for collaboration on QlikView Scripting.
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..
In your chart "-" is coming because you have some data (used in expression fields) but month is not abilable for those datas.
You have to check your data modelling.
This is because of null values in the chart.
In the Dimension Check >Suppress null values option
if I supress this, it only shows the month were are an amount,
my intention is to show the trend with all months, even if there is not an amount.
there is no other in my expression.
I have only sum(amount) in my expression
Issue is some Amount data don't have month. you have to check ur data or data modelling (Linking fields)
yea, right, because some months don't have amount, but how can I express, to show that NULL as zero or something like that..
my intention is, to show the NULL or the months, where isnt an amount like Okt, Nov, Dez,...
or just simple here
but in FMonths isnt an amount, so it supress that ..
In dimension if(isnull(Dimension field),'Not Mapped',Dimension Field)
you want to show "0" instead of 14,167?
Do you try 'NullAsValue' function ?