Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I´m new at qlik so my questions may be very basic, but I guess we all started somehow similar and iw worse not to ask.
I have a table similar to this:
If I want to sum the entire Value column I use:
Sum(Value)
(expected result: 254)
If I want to sum Value for the Month 1 I use:
Sum({<Month={1}>}Value)
(expected result: 102)
But, how do I sum Value for the Month 1 AND Broker BA ?
(expected result: 62)
And how would it be to sum Value for month 1 AND Broker BA AND Stock A ?
(expected result: 10)
THANK YOU SO MUCH IN ADVANCE!
PS: Im using qlik sense cloud
Hey Alejandro,
This is what you need for your 1st and 2nd respectively:
Sum({<Month={1}, Broker={'BA'}>}Value)
Sum({<Month={1}, Broker={'BA'},Stock={'A'}>}Value)
Hey Alejandro,
This is what you need for your 1st and 2nd respectively:
Sum({<Month={1}, Broker={'BA'}>}Value)
Sum({<Month={1}, Broker={'BA'},Stock={'A'}>}Value)