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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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