Discussion Board for collaboration related to QlikView App Development.
I have a table that is connected to another one.
When I create a pivot table for the first table I have something like this:
I mean I dont need this "-" values, cause it looks kinda ugly. I thing the reason is that my current table is connected to the other one.
I ticked "Suppress Zero values" and Suppress Missing, but it's still the same.
Any ideas why it can be like this?
I assume those are not 0 but NULL.
Try to use ISNULL in your load or IF(TRIM(LEN(yourfield))="".....
The quickest solution is to try this... remove the hyphen shown below under the 'Presentation' Tab.
are u applied on all ur dimensions in ur chart?,the same setting u mentioned this thread i.e "Suppress Zero values"!