topic Re: BLANK RECORDS in QlikView

BLANK RECORDS

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

Hi,

I have used below expression in calculated dimension

=if(NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)=8500 or NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)=12400,'',

if(NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)>0, PDARCH_COMMON_EVENT_ADDRESS,XSTREET1 &' / '& XSTREET2))

Getting blank records on Table.

I need to give the name for blank records as Stations.

Please help me to put the condition on above calculated dimension condition.

Please find the attachment to see the table.

Thanks,

sunny_talwar — Wed, 14 Sep 2016 16:17:05 GMT

May be this:

=If(Num(PDARCH_COMMON_EVENT.STREET_NUMBER) = 8500 or Num(PDARCH_COMMON_EVENT.STREET_NUMBER) = 12400, 'Station',

If(Num(PDARCH_COMMON_EVENT.STREET_NUMBER) > 0, PDARCH_COMMON_EVENT_ADDRESS,XSTREET1 &' / '& XSTREET2))

bhavvibudagam — Wed, 14 Sep 2016 16:22:16 GMT

THANK YOU