This content has been marked as final. Show 8 replies
I´ll be probably making a very basic and silly question, but Im new
I have a table similar to this:
I want to make a pie chart to show how much dollars are per broker in a specific month.
In dimension I set the broker
In measure, if I use sum(value) it sums all the values, giving me always the following:
Broker A: 62
Broker B: 51
My expected result would be that if I create a chart for month 1 get the following values in the chart:
Broker A: 30
Broker B: 30
How do I make some kind of conditional SUM? (sum only when month equals 1) or there is another way?
THANK YOU SO MUCH IN ADVANCE!
PS: Im using qlik sense cloud