topic Tables disappear without data in QlikView

Tables disappear without data

Wed, 06 Apr 2011 09:58:57 GMT

i built straight tables that every row is a diffrent calculation.

my problem is that: if i dont have data to show - like if the user chose (year=2010) and i dont have data for this year , the table disappear!!

i've tried to handle this with 'isnull' function , but it didnt succeed.

what should i do?

thanks

vincent_ardiet — Wed, 06 Apr 2011 10:13:46 GMT

Hi,

Have you try to use the calculation condition in the properties of your table (general tab) ?

With a formula like =Count(distinct [key field])>0 , you will have a message instead of no table.

Regards,

Vincent

Wed, 06 Apr 2011 10:20:01 GMT

this is my exp: sum({$<FACT_TAFTAF_KVUZAT_IFYUN ={'pigurim'}>}FACT_TAFTAF_Open_TafTAf)

in each row thete is diferent expretion.

i think i need some function that can handle with null values and perform 0 instead

thanks

prieper — Wed, 06 Apr 2011 10:23:09 GMT

Under Properties - Presentation you may untick "Suppress Zero Values" and/or untick "Suppress Missing"

HTH
Peter

Wed, 06 Apr 2011 11:13:09 GMT

hi peter

thank you , this realy was the problem.

i never thought the answer is so simple..

elad