Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

BLANK RECORDS

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,

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

2 Replies
sunny_talwar

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
Creator II
Creator II
Author

THANK YOU