topic Re: Simple Conditional Expression on chart in QlikView

Simple Conditional Expression on chart

Wed, 03 Sep 2014 08:21:46 GMT

Dear all,

I have a very simple chart with only one dimension "Category" and its values are : 1,2,3,4 .

I have created a very simple chart object on which on the dimension's tab I have only the "Category" dimension and on the expression tab I want to show static numbers with the "Conditional" button enabled for each category.

For example, if Category=1 I want the expression to return 1000 , if Category=2 I want the expression to return 2000 etc.

What is the expression I should use on the conditional box in the expression tab of my chart??

Thank you all

Re: Simple Conditional Expression on chart

Yousef_Amarneh — Wed, 03 Sep 2014 08:25:57 GMT

can you share the example, I cannot understand your request very well.

Re: Simple Conditional Expression on chart

tresB — Wed, 03 Sep 2014 08:30:48 GMT

Perhaps, you don't need conditional expression but the main expression, like:

Dimension: Category

Expression: =Pick(Match(Category, '1', '2', '3', '4'), '1000', '2000', '3000', '4000')

Or,

If it follows a certain rule, try expression like: =Category*1000

Re: Simple Conditional Expression on chart

Wed, 03 Sep 2014 08:31:29 GMT

I want to show the static number 1000 only when Category==1. Category is on the dimension's tab and it's values are 1,2,3,4. In the following screenshot on the yellow box I need the expression to make the check if ( category==1)

Re: Simple Conditional Expression on chart

maxgro — Wed, 03 Sep 2014 08:31:53 GMT

don't use conditional

and try with this expression

pick(wildmatch(Category, '1', '2', '3', '4'), 1000,2000,3000, 4000)

Re: Simple Conditional Expression on chart

Wed, 03 Sep 2014 08:40:29 GMT

Both answers mr tresesco and mr Massimo Grossi where correct and thank you very much for your valuable time. I hope to had the chance to mark both as correct. I wonder if anyone could inform me about any online developer guide or manual about set analysis functions and examples.

Yours sincerely,

Re: Re: Simple Conditional Expression on chart

tresB — Wed, 03 Sep 2014 08:44:50 GMT

See attched: