topic Label/Expression syntax in QlikView

Label/Expression syntax

Mon, 11 Jul 2011 20:01:13 GMT

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

Label/Expression syntax

rwunderlich — Mon, 11 Jul 2011 20:26:00 GMT

Is only one Call_Source always selected?

-Rob

Label/Expression syntax

Mon, 11 Jul 2011 20:28:19 GMT

Yes, only one source.

Label/Expression syntax

rwunderlich — Mon, 11 Jul 2011 20:48:37 GMT

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

Label/Expression syntax

Tue, 12 Jul 2011 00:45:02 GMT

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