Sum () based on type=Active

[#1]

Hi, I want to create a metric based on the type=Active like Sum(Revenue) based on Type=Active How I can implement in Qlikview Chart?? Thanks,

[Sokkorn · Accepted solution]

Hi Madu,

Your expression should be like this

Sum({$<[Type]={'Active'}>} Revenue)

Regards,

Sokkorn

[#3]

Thanks Sokk, it worked perfectly.