Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
naykesh4ev
Contributor

Count blanks in Pivot - Show in text box

Hi,

Is there a way to count blanks in a pivot and display the answer in a text box.

In my screenshot below, how do I count the blanks (those circled in blue) ?

My formula for the expression is as follows

if(Sum(Sales) <=0, chr(10007),' ')

Kind regards,

Nayan

pivot 2.JPG

4 Replies
YoussefBelloum
Esteemed Contributor

Re: Count blanks in Pivot - Show in text box

Hi,

for foreign_exchange measure for example, in textbox;

(supposing that your foreign_exchange expression is sum(foreign_exchange)

=aggr(sum({<foreign_exchange={"=len(trim(foreign_exchange))=0"}>}foreign_exchange),Parent,Legal_entity)

naykesh4ev
Contributor

Re: Count blanks in Pivot - Show in text box

Hi Youssef

Thank you for your reply.  I've tried that , but does not work.  The screenshot that i have given is a pivot table and there is only one formula.  The headings that you see are values of a horizontal dimension in a pivot.

Kind regards

Nayan

YoussefBelloum
Esteemed Contributor

Re: Count blanks in Pivot - Show in text box

so try this:

=aggr(sum({<legal_entity={"=len(trim(legal_entity))=0"}>}leagl_entity),Parent)

naykesh4ev
Contributor

Re: Count blanks in Pivot - Show in text box

Thank you Youssef.  Will try and let you know.

Kind regards

Nayan

Community Browser