topic Re: Do not create a date whem value is null in QlikView

Do not create a date whem value is null

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

I'm using the following script to create a calendar,

LET vStartDate = num(Floor(YearStart(Today(),-4))); LET vEndDate = num(Floor(Today())); LET vToday = num(Today()); LET vYesterday = num(Today()-1); Calendar: LOAD Date#(date($(vStartDate) + RowNo() - 1), 'DD/MM/YYYY') as PERI, QuarterName(Date#(date($(vStartDate) + RowNo() - 1), 'DD/MM/YYYY')) as QUAR AUTOGENERATE $(vEndDate) - $(vStartDate) + 1;

So, I have all dates from a period of time,

After that, I'm loading some data with Dates and Values, as you can see at the table below:

It's showing R$ 0,00 because there is no value for VDAA, but the date PERI exists...

So, my question is:
How can I do not show dates (PERI) when the value of VDAA is null?

Thanks

Bruno Lelli

Re: Do not create a date whem value is null

chrismarlow — Sat, 16 May 2020 15:44:24 GMT

Hi,

I am assuming that is a straight table where PERI is your dimension and the other 4 columns are measures.

I think it is showing values because your right 2 LOPP columns use TOTAL somehow, so for the dates (that look like weekends) you still get values. If you have a straight table with just PERI & VDAA do you have the same problem?

Cheers,

Chris.

Re: Do not create a date whem value is null

Taoufiq_Zarra — Sat, 16 May 2020 15:47:35 GMT

Maye be if VDAA is not a mesure and for pivot table you can :

Add Calculated Dimension ...

=if(VDAA>0,PERI)

and

Suppress When Value Is Null

otherwise can you share any other information !

Re: Do not create a date whem value is null

brunolelli87 — Sat, 16 May 2020 15:50:29 GMT

Good,
Thanks!

Re: Do not create a date whem value is null

brunolelli87 — Sat, 16 May 2020 15:51:52 GMT

Hello,

Thanks for your help,

PERI is my dimension and the other fields are expression...
I solved it using the following expression provided below: =if(VDAA>0,PERI)

Thanks for all your help,
Best regards