topic Re: To Build Logic in QlikView

To Build Logic

abhaysingh — Thu, 28 Aug 2014 07:03:23 GMT

Hello every one i want to show below analysis.

AvgSale/Month	Total Dealer	Product Sales(Avg/Month)	Total Outstanding
<=10K
>10K && <=30K
>30K && <= 80K
>80K && <=150K
>150K && <= 200K
200K && <=300K
>300K && <=375K
>375K && <=500K
>500K && <=750K
>750K && <=1000K
>1000K

I am able to make the buckets on the basis of sales but facing issue to show overall analysis.

Please help technically to build this.

Re: To Build Logic

Thu, 28 Aug 2014 07:06:54 GMT

Please post some data

Thanks,

Sri

Re: To Build Logic

abhaysingh — Thu, 28 Aug 2014 07:09:21 GMT

what you required exactly so i can post it in better way

Re: To Build Logic

ashfaq_haseeb — Thu, 28 Aug 2014 07:10:08 GMT

Hi,

use class() function.

Regards

ASHFAQ

Re: To Build Logic

avinashelite — Thu, 28 Aug 2014 07:10:12 GMT

Hi Abhay,

Create interval for those values like below eg.

Interval_Table:

LOAD * Inline

[

Low,High,Group

0,10,0-10 Score

10.01,20,10-20 Score

20.01,50,20 - 50 Score

50.01,70,50 - 70 Score

70.01,100,70 - 100 Score

];

Result:

IntervalMatch ( [Acquired Grade])

LOAD Low, High

Resident

Interval_Table;

Re: To Build Logic

abhaysingh — Thu, 28 Aug 2014 07:27:39 GMT

hi avinash

could u pls elaborate me more like,

what is low and high values??

acquired grade???

Re: To Build Logic

avinashelite — Thu, 28 Aug 2014 07:35:31 GMT

Hi Abhay,

This an example I am showing below.

In order to get the values between a range for eg between 0to100, 100 to 500 etc you need to create a interval for it like 0-100 one interval and 100-500 one interval. This is what i am trying to do.

Here Low and High are the range value, to take your scenario

0-10,000 is a interval so first define the that inerval low(0) and High(10,000) end so that you will get all the values within this range.

Acquired Grade is an eg field for which you want to create the interval. In your case may be Total Outstanding.

Interval_Table:

LOAD * Inline

[

Low,High,Group

0,10,0-10 Score

10.01,20,10-20 Score

20.01,50,20 - 50 Score

50.01,70,50 - 70 Score

70.01,100,70 - 100 Score

];

Result:

IntervalMatch ( [Acquired Grade])

LOAD Low, High

Resident

Interval_Table;