topic Re: Best way to create an If statement in QlikView

Best way to create an If statement

Wed, 25 Nov 2020 16:16:04 GMT

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,'')

Re: Best way to create an If statement

vishsaggi — Tue, 29 Nov 2016 21:56:20 GMT

May be like this?

= IF(match([Expenditure Type], 'FB', 'Wage', 'Emp'), 'FB')

Re: Best way to create an If statement

Anil_Babu_Samineni — Wed, 30 Nov 2016 00:55:12 GMT

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'),'')

Re: Best way to create an If statement

ramasaisaksoft — Wed, 30 Nov 2016 06:31:06 GMT

Hi Tara,

check like this

IF([Expenditure Type]='FB' or [Expenditure Type]='Wage Emp',FB,[Expenditure Type])

Re: Best way to create an If statement

Wed, 30 Nov 2016 15:15:36 GMT

Thank you, this worked perfectly.

Re: Best way to create an If statement

Wed, 30 Nov 2016 15:16:47 GMT

Thank you for the assistance. I was finally able to make it work.

Re: Best way to create an If statement

Wed, 30 Nov 2016 15:16:48 GMT

Thank you for the assistance. I was finally able to make it work.

Re: Best way to create an If statement

jhamard — Wed, 30 Nov 2016 15:22:50 GMT

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

];

Re: Best way to create an If statement

rupamjyotidas — Wed, 30 Nov 2016 16:50:47 GMT

Can you close the thread. If its working now