topic dual function in QlikView

dual function

Anonymous — Tue, 25 Jul 2017 13:10:43 GMT

dual(replace(Class(field,3),'<= x <','-'),Class(field,3))

i have values from 0 to 9 in my field

so now whats happening with above statement is :

there are 3 groups created

0-3

3-6

6-9

9-12

what i want is groups till 6-9 only

0-3

3-6

6-9

how i shud do it?

Re: dual function

sunny_talwar — Tue, 25 Jul 2017 13:33:59 GMT

May be make it like this

If(field >= 0 and field <= 3, Dual('0-3', 1),

If(field <= 6, Dual('3-6', 2),

If(field <= 9, Dual('6-9', 3))))

Re: dual function

aarkay29 — Tue, 25 Jul 2017 13:35:12 GMT

if(field>0 and field <3, 0-3,

if(field>=3 and field<6,3-6,6-9)) as Buckets

Class would not work for your requirement because class(field,3) would evaluate

0<=x<3

3<=x<6

6<=x<9 Less than 9 so it gives extra value 9<=x<12

Re: dual function

Miguel_Angel_Baeyens — Tue, 25 Jul 2017 13:35:30 GMT

Class() creates a value where each of the inputs can be between a range. The higher bound, in this case 9, will be in the range 9-12, if you want to only display 0-9, you should convert in the value to 8 for the sake of the function, so the upper bound is never higher than 9 yet the class 6-9 returns everything including 9:

Replace(Class(If(field = 9, 8, field), 3),'<= x <','-')

Re: dual function

Anonymous — Wed, 26 Jul 2017 08:46:22 GMT

my requirement is like

1-3

4-6

7-9

Re: dual function

Anonymous — Wed, 26 Jul 2017 09:48:21 GMT

i also want to have a drill down feature

if i click on range 1-3 so it should show me the drill down values

of 1,2 and 3

Re: dual function

sunny_talwar — Wed, 26 Jul 2017 11:03:21 GMT

Check the attached file....

And please try to be clear with your requirement... the reason I say this is because first you wanted groups of 0-3, 3-6, 6-9 and then you changed it to 0, 1-3, 4-6, 7-9....

Best,

Sunny

Re: dual function

Anonymous — Wed, 26 Jul 2017 11:21:36 GMT

thanks,i got the grouping but can you please help how i should get the view like:

if i click on any of the range it should show me all the values in that range

suppose its

3-6

i should be able to see

3 4 5 6 values

Re: dual function

sunny_talwar — Wed, 26 Jul 2017 11:24:19 GMT

Did you even open my application? Please check the application where I have created a drill down group which does exactly what you want.

Re: dual function

Anonymous — Wed, 26 Jul 2017 11:54:19 GMT

thanks so much

but how is this working?

can u please help for the same

and also i have a cyclic group and a combo chart,will it work the same way?

Re: dual function

sunny_talwar — Wed, 26 Jul 2017 11:56:44 GMT

I am not sure what you mean when you say how is this working? Can you elaborate on what exactly you don't understand?

Yes, it should work with combo chart

Re: dual function

Anonymous — Wed, 26 Jul 2017 12:33:09 GMT

thanks sunny so much,it resolved my issue

thanks a lot,

just one doubt please?

though its working fine but actually i have 5 fields like this having the same ranges(0-9),

so earlier i was creating a cyclic group to show it as a dimension ,

but now in this case how i shud achieve it ,though i still want this drill down feature for all the fields as well

thanks in advance,

sorry for troubling,

Re: dual function

sunny_talwar — Wed, 26 Jul 2017 12:34:59 GMT

I am not sure I understand the final goal you want... would you be able to share a sample with the expected output?

Re: dual function

Anonymous — Wed, 26 Jul 2017 13:21:50 GMT

i have fields:

fields values

a 0,1,2,3.........9

b 0,1,2,3.........9

c 0,1,2,3.........9

d 0,1,2,3.........9

e 0,1,2,3.........9

somehow these fields are related

so i want to group it together

i created a cyclic group but also need tthe above drill down functionality,would it be possible in the same chart

Re: dual function

sunny_talwar — Wed, 26 Jul 2017 13:29:39 GMT

somehow these fields are related

You are hilarious.... anyways, I think we are not getting anywhere with this discussion. I will let someone else help you out here

All the best