Class,Replace,Dual Functions

Anonymous — Tue, 22 Jul 2025 17:59:49 GMT

Hi,

I would like to discuss about CLASS,REPLACE,DUAL functions in qlikview. I will explain these functions by taking a sample business scenario.

U Can observe that for different Sale Id we have different Sale Amount. Now, Our requirement is that our organization wants to organize all the sales based on range.

Desired output

Follow , the below steps inorder to obtain the desired output.

Right click-->NewSheetObject-->Straight Table
In the Dimensions tab,U hav to add calculated Dimension

CLASS Function

syntax:- Class([Desired field],range)

After adding the Calculated Dimension,click Next
Add Expression as count[SaleId]

The output obtained is,

Now, if you want to remove '<= x <' symbols in between the numbers, u can use replace function.

Replace

Edit the calculated dimension as -->

Syntax: Replace([field],'what you want to replace','what should be replaced')

Output :

U can , now observe that '<= x <' is replaced with '-'.

However, you can see that range values are not sorted correctly . To, rearrange them in a proper order with equi range distribution You can use DUAL function.

DUAL

Edit the calculated dimension as -->

Output:

You can now observe that Sales range is ordered accordingly and Count of sales can be observed easily by seeing the above table.

Final Output:-

Note: I dn't want to see those sales which are not in range. so,I have checked, Supress Null Values i.e why u can't see 600-700 ,800-900,.....2200-2300 in Sales range column .

Like/Mark my document as HELPFUL if u find it useful for you.

Thanks & Regards,

K.bharat

Re: Class,Replace,Dual Functions

sunny_talwar — Thu, 19 Jan 2017 16:19:19 GMT

Thanks for sharing.

I would also suggest you to attach the qvw file also for people to explore this on there own.

Best,

Sunny

topic Re: Class,Replace,Dual Functions in Archived Groups

Class,Replace,Dual Functions

Re: Class,Replace,Dual Functions