topic Re: If Condition - Help in QlikView

If Condition - Help

satishkurra — Tue, 09 Feb 2016 16:31:41 GMT

Currently i have the below if condition as Popu Up Label

if(GetSelectedCount(Project_Name)= 0 ,sum(Sales),sum(Cost))

Sales and Cost Value is ranging from values 10 - 1000

Now the change is for the Sales and Cost Value < 100, should not display the individual values but it show the label as simply < 100

But for the values > 100, should display the individual Sum(Sales) and Sum(Cost)

Can someone help me on this?

Thanks

Satish

sunny_talwar — Tue, 09 Feb 2016 16:33:39 GMT

May be this:

If(GetSelectedCount(Project_Name) = 0,

If(Sum(Sales) < 100, '<100', Sum(Sales)),

If(Sum(Cost) < 100, '<100', Sum(Cost)))

satishkurra — Tue, 09 Feb 2016 16:57:51 GMT

Thanks Sunny. It worked...