Discussion board where members can get started with Qlik Sense.
I am totally confused.
Is there way to show missing values as Zero ('0')?
I know that these values are non-existent in this fields, but I am sure there should be a way of showin it as zeros.
I am using mastercalendar, if it matters.
This is my datamodel:
Go to Solution.
I prepared a demo for you...
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
for i= MakeDate(2018,1,1) to MakeDate(2018,3,31)
LOAD Date($(i)) as Datefield AutoGenerate 1;
LOAD *,Datefield&'|'&Operation as TEMPKEY;
LOAD *INLINE [
Datefield, Operation, Amount
2018-01-15, Sales, 500
2018-02-15, Sales, 1000
2018-03-15, Purchases, -400
//fill up Sales
Datefield, 0 as Amount, 'Sales' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Sales');
//fill up Purchases
Datefield, 0 as Amount, 'Purchases' as Operation resident Master
where not Exists(TEMPKEY,Datefield&'|Purchases');
drop field TEMPKEY;
if (len(value)>0, value, 0)
can u please add in the script:
SET NullValue ='0' ;
reload and see what happens?
Tried thisdoes not work
does not work both in the sript and in the formula
I think it won't solve the problem
because I have data missing on weekends, and therefore, it just does not record anything on weekends, so there is nothing to check for length
You need to put it in the chart and value is the formula or what ever you calculate. This should work.
Isn't there any option as there is one in QlikView?!?
Please share your sample application or data?
no )Sense is sooooo limited on this