Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display values of a specific field

Hi all,

I have a dataset that containts several values. How can I set a summary box on my dashboard that only shows the total amount for a specific value?

More concrete: I have invoices that should have a Tax code assigned to them. On the main page of my dashboard I want to have a table, graph... that always shows the number of invoices without a Tax code assigned. I can create a graph that plots all Tax Codes and there I see the number of invoices without one assigned but I would like to have a specific indicator on my main dashboard only showing those invoices.

I tried to do this by creating a statement in my expression:

count(if(TAX_CODE= '(Null)',1,0))

but this doesn't return the expected result. Is there any other way to do this?

Thanks in advance,

Kind regards,

Jens

1 Reply
eliran
Creator III
Creator III

Hello Jens,

I suggest using set analysis as follows:

Where you will use another field to count

Count({<TAX_Code={''}>}FieldToCount)

attach is an example.

Hope it helps,

Eliran