counts inside a pivot tabley

Thu, 27 Feb 2014 01:03:17 GMT

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

topic counts inside a pivot tabley in QlikView