Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I'm stuck with a situation in qlik sense and I could really use some help.
I create an aggregated count formula as a master dimension which work fine as a dimension in a table with the desired result. But if I try to use the same formula as a master measure the result doesn't behave like a number in a pivot.
I want to count how many items are sold per the aggregated categories. I want to use this formula as a part of an Exact value limitation or as a condition in an average calculation (both is ok for the task but none of the approaches worked because the formula doesn't result a number).
To complete my task I need to multiply the result thats why I need this formula to behave like a number.
My formula is:
aggr ( count(item_code), customertype, month, productcategory, producttype, ZIPcode)
I tried num and num# but none of it works. Tried to use as a variable too but still doesn't behave like a number.
Any ideas?
Can you share what is shown?
I would expect that return as a number due to the count() function.
When is shown when you try using as above.?
Hi Mark,
I cannot share my screen because of sensitive data is on the table and the pivot.
The result I get is mostly null I think (it shows this: - ) but the editor says the formula is ok.
I tried to use the count without aggregation (and let the pivot do the separation) but then it counted all my items regardless of the columns before.
Thanks,
Morcella