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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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...