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

Label/Expression syntax

This is giving me fits, I have a Field, Response_Time, that is bucketed into different SLA time brackets (Live, Electronic and Other) from a call center application. I have an IF Expression statement working to select/count the call data according to the dynamic GetFieldSelection(xxxxxx)  but can't get the Expression Label to work dynamically for the heading.

=if(GetfieldSelections(Call_Source)='Live','< 1 minute') works But extending it with another If like the Data selects doesn't.

=if(GetFieldSelections(Call_Source)='Live','< 1 minute'), if(GetFieldSelections(Call_Source)='Electronic','< 5 minutes'), if(GetFieldSelections(Call_Source)='Other','< 7 minutes'),

Thanks

David Rowe

1 Solution

Accepted Solutions

Label/Expression syntax

Leave off the GetFieldSelections() and just try:

=if(Call_Source='Live','< 1 minute'

, if(Call_Source='Electronic','< 5 minutes'

, if(Call_Source='Other','< 7 minutes'

, '????'

)))

-Rob

http://robwunderlich.com

4 Replies

Label/Expression syntax

Is only one Call_Source always selected?

-Rob

Not applicable

Label/Expression syntax

Yes, only one source.

Label/Expression syntax

Leave off the GetFieldSelections() and just try:

=if(Call_Source='Live','< 1 minute'

, if(Call_Source='Electronic','< 5 minutes'

, if(Call_Source='Other','< 7 minutes'

, '????'

)))

-Rob

http://robwunderlich.com

Not applicable

Label/Expression syntax

Thanks Rob. Good pointer, made sense as a single source.

DR

Community Browser