Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Exclude blank/null from straight table

I have a data set with a column for Name_of_Covered_Drug and a column for the Total_Spend associated to that drug. There is some spend reported that is not associated to a drug so the Name_of_Covered_Drug can be blank. I want a table showing top 10 drugs by spend  but my table keeps including a single bar grouping all the blank drug names. I tried "Suppress when value is null" in Dimensions and I also tried the expression of

Sum ({$<Name_of_Covered_Drug-={NULL}>}Total_Spend)

also Sum ({$<Name_of_Covered_Drug={"*"}>} Total_Spend)

Any advice on how to type expression so that it will give me Total Spend only when a drug name is present(excluding nulls)?

Thanks

1 Solution

Accepted Solutions

Re: Exclude blank/null from straight table

Can you try this as your dimension:

If(Len(Trim(Name_of_Covered_Drug)) > 0, Name_of_Covered_Drug)


and now select 'Suppress When Value Is Null' on the dimensions tab

2 Replies

Re: Exclude blank/null from straight table

Can you try this as your dimension:

If(Len(Trim(Name_of_Covered_Drug)) > 0, Name_of_Covered_Drug)


and now select 'Suppress When Value Is Null' on the dimensions tab

Not applicable

Re: Exclude blank/null from straight table

Perfect! Thank you

Community Browser