Discussion Board for collaboration regarding Qlik DataMarket.
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?
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')
i using this when i created a chart. no in the script
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)
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.
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.