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

counts inside a pivot tabley

Hi!!! I have one big table with a lot of rows and another table which is a catalog

im making a pivot table with one dimension (so the records get group by that dimension)

and some expresions like this:

count({<TP={VALUE1},TB={VALUE2}>}NOMBRE)

and

count{<TP={VALUE1},TB={VALUE2},RP={VALUE3}>}%IDCAT)

WHERE %IDCAT,TP,TB,NOMBRE ARE FIELDS FROM THE CATALOG TABLE

AND RP,%IDCAT ARE FIELDS FROM THE BIG TABLE

the problem that I have is that when it shows the count of the second expresion is ok

but the first expresion isnt counting rows from the catalog that doesnt have a match in the main or big table

and I need that it also count that rows, any idea so I can get also that rows?

sorry about my English

0 Replies