topic How to restrict the values in KPI(Straight Table) in QlikView

How to restrict the values in KPI(Straight Table)

Wed, 12 Apr 2017 17:35:23 GMT

Hi ,

I have a straight table having the below KPIs and Dimensions.

My Last KPI Email flag condition is having values "Flag " and spaces.I want to show only "Flag" values in my chart,dont want to show

spaces.

Logic for Email flag condition is:

if([CP Budget]=0,'',if([ResidentDays Budget]=0,'',if([Meals Budget]=0,'',if([CP Actual]>=[CP Budget]*1.15,'Flag',if([CP Actual]<=[CP Budget]*0.85,'Flag',

if([ResidentDays Actual]>=[ResidentDays Budget]*1.15,'Flag',if([ResidentDays Actual]<=[ResidentDays Budget]*0.85,'Flag',

if([Meals Actual]>=[Meals Budget]*1.15,'Flag',if([Meals Actual]<=[Meals Budget]*0.85,'Flag',''))))))))).

Can any one please help on this.

Thanks,

Krishna

Re: How to restrict the values in KPI(Straight Table)

Anil_Babu_Samineni — Wed, 12 Apr 2017 17:39:41 GMT

Try to create one more column with Column(7)>0 and then check, How this works

Re: How to restrict the values in KPI(Straight Table)

Wed, 12 Apr 2017 17:49:20 GMT

Hi,

For the column(7), what is the logic i should provide.

I didn't get, can you explain me.

Re: How to restrict the values in KPI(Straight Table)

Anil_Babu_Samineni — Wed, 12 Apr 2017 17:51:30 GMT

Do you create that logic in script or UI. If it is script then use Flag > 0 or if it is in UI then you can use Expression > 0

If(Len(Expression) >0, Expression)

Re: How to restrict the values in KPI(Straight Table)

Wed, 12 Apr 2017 18:16:26 GMT

Still Some Nulls are coming.