Hi, i am new to Qlik, would like to group part of dimension.

[#1]

In my dimension data there are negative value (-7 to -1), and then '0' onwards, i would like to group -ve value as one group, call it '-ve' and would like to take rest dimension as is in axis.

[Anil_Babu_Samineni]

May be use this

If(Len(Sum(Sales))<0, '-ve', rest) as Dimension

Then use Calculation as per your need

[ramasaisaksoft]

Hi Pankaj,

Check this also

if(num(Dim)<0,'-Ve',Dim) as Dim

for your practice

=if(num(-5)<0,'-Ve',5)

[#4]

Try like this

if(sign(sum(sales))=-1,'Negative','Positive') as Dim

[avinashelite]

in the front end expression

If(Sum(Sales)<0, '-Ve', Sum(Sales))

//script

if(Sales<0,'-Ve',Sales) as Sales_New