Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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))

View solution in original post

bhavvibudagam
Creator II
Creator II
Author

THANK YOU