Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

suggest

Hi All

Please suggest how shall i proceed with below mention scenario

where row labels is the difference of two dates from same table...

how to make buckets in backend

Row Labels

Count of Reservation Status

<0

84

0-30

19704

30-60

19334

60-90

13078

90-120

11236

120-150

10777

150-180

9029

>180

255

Grand Total

83497

thanks in Advance

3 Replies

Re: suggest

Hi,

Have a look at class() function.

Regards

ASHFAQ

sujeetsingh
Honored Contributor III

Re: suggest

Class() function is a good way..even you can use nested if conditions but it will take a lots of memory and calculation time .

Not applicable

Re: suggest

Use Class() function. You can also use IntervalMatch in the script.

Community Browser