Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Condition

hello,

I would set a condition like this:

If(A_DESCR_LINEA_PRODOTTO = ('atr' and 'atr42 sez. 15' and 'atr72 sez. 15'), 'ATR_21') 

that is, I would like to group certain values with a single word.

I have set the condition in chart in the field of the tab size conditions but non function.

can you help me?

5 Replies
MVP
MVP

Re: Condition

Where exactely are you using this expression?

In a calculated dimension, try

=If(Match(A_DESCR_LINEA_PRODOTTO,'atr', 'atr42 sez. 15','atr72 sez. 15'), 'ATR_21')

Not applicable

Re: Condition

i using this when i created a chart. no in the script

MVP
MVP

Re: Condition

Right, but to group your dimension field, I think you should use a calculated dimension on dimension tab (or create a field in the script).

If you want to group the three value under 'ATR_21', but keep all other field values,use

=If(Match(A_DESCR_LINEA_PRODOTTO,'atr', 'atr42 sez. 15','atr72 sez. 15'), 'ATR_21',A_DESCR_LINEA_PRODOTTO)

Not applicable

Re: Condition

I have insert this to creat a condition in the calculate dimension, but not function, it create other field (ART_21) but i see all group.

MVP
MVP

Re: Condition

Don't input this in the dimension conditional expression, which is like switching on/off the complete dimension based on a condition (global for the chart).

Use a calculated dimension on dimension tab.

Community Browser