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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Date help

Hi Experts,

Can any one please help me on below requirement.

From below table

I need to count the IssueNo when Create > DueDate and [Item New String]='Authorised' and [Item Field] ='Staus' in KPi

Please help me to write the expression.

Thanks in advance.

10 Replies
YoussefBelloum
Champion
Champion

I forgot that..

You can take the last dimension and put it as an expression using Only()

Just change the count() to Only()