Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My qlik sense pivot table uses Sales_Category as first dimension, Customer as second dimension, but this query only extracts customers who have sales category. I have another full customer list, and want each customer shows under each sales category. Is it possible?
Thanks for help!
I'm not positive without trying it. But if you load all of your customers then you should see a Sales_Category at the top of the list that is blank or null with those customers under it.
It does. But I don't want to show those customers under Null sales category. Is it possible to show them under each NotNull sales category?
If they don't have a sales category how would you do that? In your load script you could give them a value of 'No Category' and then they would all show up under that section.
But the Pivot Table is going to lump them all together under the null or empty value since that is what the data is.