Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ramya_beginner
Creator
Creator

Set Analysis Help

I have a basic question here , say for example in the below expression, There is no data for Region = South , for a certain filter value , what would be the output of this expression , when i select that filter value which does not have any data South Region it shows just a dash ,  which is fine but , i need to sum up this value with another expression , so even though that another expression has a value when i sum up with this expression i am getting dash , how do i avoid this ...?

sum({$<Region = {'South'},Year = {'2010'}>Sales}

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Use the rangesum function instead of the + operator: rangesum( sum({$<Region = {'South'},Year = {'2010'}>Sales), other_expression_here ). Or use the alt function:

alt(sum({$<Region = {'South'},Year = {'2010'}>Sales) , 0) + other_expression_here


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Use the rangesum function instead of the + operator: rangesum( sum({$<Region = {'South'},Year = {'2010'}>Sales), other_expression_here ). Or use the alt function:

alt(sum({$<Region = {'South'},Year = {'2010'}>Sales) , 0) + other_expression_here


talk is cheap, supply exceeds demand

View solution in original post

MayilVahanan

Hi

Try with

Alt(sum({$<Region = {'South'},Year = {'2010'}>Sales) , 0)

hope it helps

Thanks & Regards,
Mayil Vahanan R