grouping qlikview

[#1]

Expressions

= fractile(Value1,.5)

=fractile (Value 2,.5)

=fractile(if(Country= India, Value1),.5)

=fractile(if(Country= India, Value2),.5)

i want to group 1,2 together and 3, 4 together it should look like

[sunny_talwar]

Would you be able to share you qvw with the expected output in Excel may be?

[#3]

here i have included only one bar ..(expression for one bar )

i have to include similarly for the other bar  as mentioned initialy

[sunny_talwar]

New Script:

LOAD city,

    state,

    Country,

    [value 1],

    value2

FROM

[Book1234.xlsx]

(ooxml, embedded labels, table is Sheet1);

LOAD * Inline [

Dim

1

2

];

Bar Chart

Dimension: Dim

Expressions:

1) =Pick(Dim, Fractile([value 1],.5), Fractile({<Country = {'India'}>} [value 1], 0.5))

2) =Pick(Dim, Fractile(value2,.5), Fractile({<Country = {'India'}>} value2, 0.5))

[#5]

can u plz send th qvw.

[oknotsen]

The QVW is already attached to his post...

[sunny_talwar · Accepted solution]

Open the link: Re: grouping qlikview

[HirisH_V7]

Hi,

Check this ,

using Value list ,

Dimension:

=ValueList(1,2)

Expressions:

=If(ValueList(1,2)=1,Fractile([value 1],.5))
=If(ValueList(1,2)=1, Fractile({<Country = {'India'}>} [value 1], 0.5))
=If(ValueList(1,2)=2,Fractile([value2],.5))
=If(ValueList(1,2)=2,Fractile({<Country = {'India'}>} value2, 0.5))

Hope this Helps,

PFA,

Hirish

[#9]

thank you so much

[#10]

i have alternate states

1,2,3

and i have state in one state

country in another

city in 3rd. i chose all and finaly i can skip the last state. in that case i should get only the rest .

means for ex if i select all the states i will get 4 bars

one is no filter

two is based on state 1

three is based on state 2

four is based on State 3

if i can skip i should show only 3 bars.

how will i do that