value?

Anonymous — Wed, 04 Feb 2015 16:13:27 GMT

i have table called

country: fields like

country:

india -100(value)

america-200

westindies-300

pakisthan-400

zimbambe-null

austrila-null

newzeland-null

in this table i am malking a croostable like

crosstable(allcountry,amount,2)

india and americal will remain same .

rest of the countries names or going store in 'allcountry' and

all these country data is going to store in amount. ,,, fine till now

here

zimbambe

austrila

newzeland dont have value it is having null .

when i go for table box with above fields

india

america

allcountry

amount

i can see data in allcountry for only westindies,pakisthan( where i have value) ,(not only data even fields are not coming up in allcountry called zimbambe, austrila ,newzeland)

my req is i want see these fields also in all country(zimbambe, austrila ,newzeland) even if value is null

and it should not display 0 instead of null

i have to see only null ( i dont want see any thing instead of null)

topic value? in QlikView

value?