Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cramkumar86
Contributor III
Contributor III
‎2023-09-08 07:41 AM

To count the number of filtered rows

HI,

I would like to show the number of filtered rows on my dashboard. Could you please help me with that?

Regards,

Ram

602 Views
0 Likes
2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II
‎2023-09-08 11:55 AM

Hi,

 

HI,

Maybe:

Count({1} AnyField) : all your row

Count(AnyField): filtred by selection

Count({1-$} AnyField) : excluded

Help users find answers! Don't forget to mark a solution that worked for you!
568 Views
0 Likes
cramkumar86
Contributor III
Contributor III
‎2023-09-13 04:45 AM
Author

In response to Aurelien_Martinez

Thank you. In the formula below, when I use only the dimensions I have on filters, it shows a value more than the actual number of rows filtered.

Count(AnyField): filtred by selection

It could be because of the measures and when they are aggregated, the number of rows fetched will be less than the value populated by formula above. How do I include the measures in the formula above?

For eg. Lets say I want to find the total number of rows based on dimensions (Region, BusinessDate) and measures (Native Currenry, Local Currency). How do I do that?

541 Views
0 Likes