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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Count the specific Values in the Column?

Hi QV Team,

I need to count only the "X' Values in the NewCars Column. Pls help me out. Pls see the attachments.

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Try this also:

count(if(match([New Cars],'X'),[New Cars]))

Thanks,

AS

View solution in original post

5 Replies
amit_saini
Master III
Master III

Hi ,

Like this???

Thanks,
AS

amit_saini
Master III
Master III

Try this also:

count(if(match([New Cars],'X'),[New Cars]))

Thanks,

AS

Not applicable
Author

No I just want to create a table and need to get the Total of NewCars and UsedCars.

amit_saini
Master III
Master III

Use count(if(match([New Cars],'X'),[New Cars])) than , you will get your result.

Thanks,
AS

amit_saini
Master III
Master III

Like this???

Thanks,

AS