Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

if Statement

=if([GL_Hierarchy Short Description2]='Profit & Loss A/C's,[GL_Hierarchy Short Description2])

getting error on this point in above statement A/C's, kindly help me to fix this out.

Regards.

1 Solution

Accepted Solutions

Re: if Statement

Hi,

Try instead

=If([GL_Hierarchy Short Description2] = 'Profit & Loss A/C' & Chr(39) & 's', [GL_Hierarchy Short Description2])

The Chr(39) substitutes the ' character.

Hope that helps.

Miguel

2 Replies

Re: if Statement

Hi,

Try instead

=If([GL_Hierarchy Short Description2] = 'Profit & Loss A/C' & Chr(39) & 's', [GL_Hierarchy Short Description2])

The Chr(39) substitutes the ' character.

Hope that helps.

Miguel

Not applicable

Re: if Statement

thnxs Miguel

Community Browser