creating buckets based on values

[dreweezy]

Hi all,

New to Qlik and have loaded in my data. I am trying to create 2 buckets based on a value of the column. If the value is a negative number then I want to create a bucket "Neg" and "Pos" if the value is positive. Can someone kindly guide me on where I can create this bucket and how the syntax should look.

Thanks.

[m_perreault · Accepted solution]

You can use the class function to create buckets in your script or in a chart.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

If you're bucket is as simple as Positive vs Negative you can create a flag in your script such as

Load,

ID,

Value,

If(Value>0,'Positive',If(Value<0,'Negative')) as Bucket

From xx;

[pradosh_thakur]

pick(match(value,fabs(value))+1,'Neg','Pos') as Bucket

[dreweezy]

I was able to create an additional column in the load script to designate whether that row/record is a Positive or Negative value. My next question - I want to create a KPI to show the count of records 'BY' a specific dimension. Let say I want to count the # of positive values by Country. How does the syntax work? When I was using Oracle BI syntax would be similar to Count(Country by Product). Thank you.