topic Re: ranges between two values in QlikView

ranges between two values

Wed, 15 Apr 2015 11:39:00 GMT

hi all,I am new to QLIKVIEW.

how to differentiate ranges in qlikview,

My requirement is,ihave a table like shown below

Resource month Allocation_Value

kishore jan 1

srikanth jan 0.8

raj jan 1.25

shilpa jan 0.5

sravani jan 1

ram jan 1.11

I want to see the,how many resources allocated between these ranges like (>=0.8 and <=1),(>=1 and<=1.15),(>=1.15 and <1.30)

in a different text objects.

Can you Please help on these,

Regards,

Sruthi Reddy

Re: ranges between two values

robert_mika — Wed, 15 Apr 2015 12:05:20 GMT

One of many

load * Inline [

Resource, month, Allocation_Value

kishore ,jan, 1

srikanth ,jan , 0.8

raj , jan , 1.25

shilpa ,jan , 0.5

sravani ,jan ,1

ram , jan ,1.11

];

join(t1)

t2:

load

Resource,

If ( Allocation_Value >=0.8 and Allocation_Value<=1,'>=0.8 and <=1',if(Allocation_Value>=1

and Allocation_Value<=1.15,'>1 and<=1.15',if(Allocation_Value>=1.15 and Allocation_Value<1.30,'>=1.15 and <1.30','not categorized'))) as Category

Resident t1;

Then you can count in Straight table

I have used "load inline " method to get your data but you can do that on data loaded from your sources.

Re: ranges between two values

anbu1984 — Wed, 15 Apr 2015 12:35:46 GMT

Try this expr in Text box

='Count of resources allocated >=0.8 and <=1 : ' & Count(If(Allocation_Value >=0.8 and Allocation_Value <=1,Resource))

Re: ranges between two values

ali_hijazi — Wed, 15 Apr 2015 12:37:26 GMT

count({<Allocation_Value={">=0.8 <=1"}>} Resource)

or you can assign ranges to variables and your expression would be

count({<Allocation_Value={">=$(From) <=$(To)"}>}Resource)

Re: ranges between two values

buzzy996 — Wed, 15 Apr 2015 12:44:37 GMT

Try these expressions,

Text Box1---

IF(Allocation_Value >=0.8 and Allocation_Value<=1,Count(Allocation_Value),null())

Text Box2---

IF(Allocation_Value>1 and Allocation_Value<=1.15,Count(Allocation_Value),null())

Text Box3---

IF(Allocation_Value>1.5 and Allocation_Value<=1.30,Count(Allocation_Value),null())

Re: ranges between two values

Wed, 15 Apr 2015 16:58:17 GMT

Hi Robert Mika,

Thanks for your Reply,I want to write expression in textobject

Data is,

Resource	month	allocation	project
kishore	jan	1	project1
kishore	jan	0.25	project2
raj	jan	0.1	project1
srikanth	jan	0.8	project1
raj	jan	1.25	project2
shilpa	jan	0.5	project1
sravani	jan	1	project1
ram	jan	1.11	project2

My requirement is when resource handling more than 1 project in a month then i want to see the sum of allocation value of resource eg(

resource=kishore,Project1=1

Project2=.25,

final o/p will be:1.25

range >1 to <=1.5

Can you please find the attachment of qvw

Regards,

Sruthi Reddy

! !

Re: ranges between two values

Wed, 15 Apr 2015 17:03:31 GMT

Hi Anbu Cheliyan,

Thanks for your Reply,

My Data is,

Resource	month	allocation	project
kishore	jan	1	project1
kishore	jan	0.25	project2
raj	jan	0.1	project1
srikanth	jan	0.8	project1
raj	jan	1.25	project2
shilpa	jan	0.5	project1
sravani	jan	1	project1
ram	jan	1.11	project2

My requirement is when resource handling more than 1 project in a month then i want to see the sum of allocation value of resource eg(

resource=kishore,Project1=1

Project2=.25,

final o/p will be:1.25

range >1 to <=1.5

Can you please find the attachment of qvw

Regards,

Sruthi Reddy

Re: ranges between two values

Wed, 15 Apr 2015 17:07:20 GMT

Please look into interval match function by defining the minimum and maximum range and pass your fact into the function which will automatically do for you.

Thanks,

Sai