Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I created a treemap colored by different dimensions and whenever I select a specific box (or item), it selects the whole category. I have to go through each categories by double clicking or hitting the green check box multiple times to get to that specific item.
Is it possible to select individual items with the first click?
Yeap, that's because it isn't the name of the field you want to use. Be aware that the field should be written exactly as it is considering Qlik Sense is case sensitive when referring to fields.
So, it is not the same SUM(SalesAmount) than SUM(salesamount).
Please check the name of the field containing the amount data you want to SUM in the formula. Use the dropdown menu in the right hand side to look up for tables and fields.
Oh! Yest that works now! But, it says it's an invalid dimension... It seems like I'm using a wrong function. Since summing dimensions don't really work haha. Is there a function to list opportunities that are in stage 1 for example?
If it says invalid dimension, then you better select the Dimension from the dropdown and select a valid Field.