Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

grouping qlikview

sample data for grouping.png

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

bsample.png

1 Solution

Accepted Solutions
19 Replies
sunny_talwar

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

Not applicable
Author

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))

Capture.PNG

Not applicable
Author

can u plz send th qvw.

oknotsen
Master III
Master III

The QVW is already attached to his post...

May you live in interesting times!
sunny_talwar

Open the link: Re: grouping qlikview

HirisH_V7
Master
Master

Hi,

Check this ,

Value List Grouping-206458.PNG

using Value list ,

Dimension:

=ValueList(1,2)

Expressions:

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

Hope this Helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Not applicable
Author

thank you so much

Not applicable
Author

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