Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am brand new to Qlik.
I have a report that reflects Expenditure Types, budgets, actuals, etc. However, the report I need to provide my supervisor has 16 categories and every expenditure type falls in one of those 16 categories.
Example:
Expenditure Type is FB, Wage Emp in a new column I want it to fall under my category FB.
Under Expressions I have created a Label of Category and have tried the following scripts.
IF([Expenditure Type]=FB Wage Emp,FB,)
IF([Expenditure Type]=FB Wage Emp,FB,'')
May be like this?
= IF(match([Expenditure Type], 'FB', 'Wage', 'Emp'), 'FB')
I am not sure, I understand your concern. but, for ref it's typo error.
Try this
Replace(IF([Expenditure Type]='FB Wage Emp','FB'),'')
Hi Tara,
check like this
IF([Expenditure Type]='FB' or [Expenditure Type]='Wage Emp',FB,[Expenditure Type])
Thank you, this worked perfectly.
Thank you for the assistance. I was finally able to make it work.
Thank you for the assistance. I was finally able to make it work.
Hi,
For what you expect IF is bullshit.
Simply LOAD a mapping table in your script and add the new field (Expenditure Type Aggr) in your chart.
LOAD * INLINE [
Expenditure Type, Expenditure Type Aggr
FB, FB
Wage Emp, FB
];
Can you close the thread. If its working now