Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to Exclude a particular record from showing from the chart.

HI!

If I need not to show a particular records in a table, what could be the expression to be used.As per the chart given below, when ever ACT<BUD, such records to be restricted from showing in the table. I expect your ideas towards this by using where clause as well as using an expression! As per the chart, Staff Welfare expense under EM, & RA are to be excluded since they are nt having a negative variance.

Thanks In Advance

Neville.

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hello!

You should use calculated dimension with this condition:

if(aggr(sum(BUD)-sum(ACT),BR_CODE,TYPE,CATEGORY)>0,Null(),BR_CODE)

and check "Suppress When Value Is Null" on Dimensions tab

hide_values.png

If you find this solution useful - please mark answer as correct or helpful and close the topic. Thank you!

View solution in original post

2 Replies
nevilledhamsiri
Specialist
Specialist
Author

Please respond!

Regds

Neville

Sergey_Shuklin
Specialist
Specialist

Hello!

You should use calculated dimension with this condition:

if(aggr(sum(BUD)-sum(ACT),BR_CODE,TYPE,CATEGORY)>0,Null(),BR_CODE)

and check "Suppress When Value Is Null" on Dimensions tab

hide_values.png

If you find this solution useful - please mark answer as correct or helpful and close the topic. Thank you!

View solution in original post