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
once you will select Month pi will change to you are looking for
but if you want to have a static chart
for ever month
Thank you everyone! I didn´t expectedsuch a fast reply and quality answers!
Three options worked in the very same way:
But I dont understand the differences among those three
Clarification would be very apprecitaed, thanks!
First and Last is same if there is no $ qlik counts it $ which tells that selection should be count in.
1 tels that selection should not be considered