Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pipuindia99
Creator III
Creator III

Expression Issue with Count of values

Please find the attachment

I want the output as count(column (C))='MET'/total count of (Column (C))

i.e., 3/6 = 2 to be shown in a text box.

would appreciate your help

15 Replies
sunny_talwar

May be this:

=Count({<name={"=A=B"}>}name)/Count(name)

pipuindia99
Creator III
Creator III
Author

It is not working

sunny_talwar

Have you looked at the attached sample? Seems to be working for me unless you have a different data model in your original app

pipuindia99
Creator III
Creator III
Author

I downloaded the attachment, it looks different what i gave it to you . but still i managed with your suggested expression. it doesnot work for me. to be more meticulous i have used dimension(name) as separate table and in expression i have added 3 expression like (exp1 - with pick match functions, exp2 - with pick match function, exp3 - exp1 compared to exp2...) and i would like to show the values in text table as required.

please help

sunny_talwar

My bad, may be I might have added the wrong qvw file

Capture.PNG

pipuindia99
Creator III
Creator III
Author

Have sent you the requirement to your email id...