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]

Not sure I understand, would you be able to elaborate with an example?

[#3]

can i have a names instead of 1, 2,3 ..etc in your example

[HirisH_V7]

Hi,

Are you asking in the Value list or What !

[#5]

we create a inline table like

DIM

1

2

3

like wise

can i create

DIM

'AA'

'BB'

'CC'

[#6]

also tell me how to show lgends for theses tyes of bar charts

[sunny_talwar]

Ya do you refer to Dim in my example or ValueList() within Hirish's example?

[#8]

yes in your solution Dim

[sunny_talwar]

You can, but I don't see a reason for doing that. Dim is just used to make Pick() function work. It is an Island table which is not supposed to be used anywhere else.

[#10]

can u show /tell where /how to provide a name instead of those numbers and help me in showing legends.

[#11]

Here i have included a example with alternate state.

in sheet 3 i am displaying the chart in which i need to show legend and separate color for each bar.

under DIM as per ur example

1,2,3,4

if any bar had zero value then it populates the next one

for ex

1 - first bar has value

2- second bar has no value so in place of 2 3rd bar appears.

in the expression under background i have used if condition for DIM for different colours.

say

1 has to be green

2 has to be blue

3 has to be brown

if 2 not there still3 should take brown. but it takes blue