Qlik Sense Table With If Condition for Conditional Grouping

[mvgadagi]

Hello,

Currently, I am new to Qlik Sense and we have the data to represent in the Qlik Table and we have the details such as

Process ID Process Val

1	5
2	49
3	101
4	250

In Qlik Sense I wanted to convert the table as below, Can you please let me know the approach for this

Count Range

2	>0<50
1	<200
1	>200

First row is a table header

[kaushiknsolanki]

Hi,

You can simply create a new field using nested IF statement like below.

Load *,

If(ProcessVal <50, 'Less than 50',

If(ProcessVal <200, '>50 & <200','>200')) as Bucket

From XYZ;

Now you can use this new field in table and use it as dimension and Count(ProcessID) as Expression.

Regards,

Kaushik Solanki

[kaushiknsolanki]

You Can also use the Class() function in dimension to get the bucket.

Check below link.

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

Regards,

Kaushik Solanki