Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to restrict the values in KPI(Straight Table)

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.

.Bud.JPG

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

4 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Hi,

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

I didn't get, can you explain me.

Anil_Babu_Samineni

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

or

If(Len(Expression) >0, Expression)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Still Some Nulls are coming.bud2.JPG