topic Re: grouping qlikview in QlikView

grouping qlikview

Mon, 22 Feb 2016 10:58:29 GMT

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

Re: grouping qlikview

sunny_talwar — Mon, 22 Feb 2016 11:31:00 GMT

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

Re: grouping qlikview

Mon, 22 Feb 2016 12:18:27 GMT

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

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

Re: grouping qlikview

sunny_talwar — Mon, 22 Feb 2016 13:22:18 GMT

New Script:

LOAD city,

state,

Country,

[value 1],

value2

FROM

[Book1234.xlsx]

(ooxml, embedded labels, table is Sheet1);

LOAD * Inline [

Dim

];

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

Re: grouping qlikview

Mon, 22 Feb 2016 14:03:39 GMT

can u plz send th qvw.

Re: grouping qlikview

oknotsen — Mon, 22 Feb 2016 14:20:11 GMT

The QVW is already attached to his post...

Re: grouping qlikview

sunny_talwar — Mon, 22 Feb 2016 14:21:40 GMT

Open the link: Re: grouping qlikview

Re: grouping qlikview

HirisH_V7 — Mon, 22 Feb 2016 14:35:44 GMT

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

Re: grouping qlikview

Mon, 22 Feb 2016 14:43:13 GMT

thank you so much

Re: grouping qlikview

Mon, 22 Feb 2016 17:35:24 GMT

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

Re: grouping qlikview

sunny_talwar — Mon, 22 Feb 2016 18:06:29 GMT

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

Re: grouping qlikview

Wed, 24 Feb 2016 05:56:30 GMT

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

Re: grouping qlikview

HirisH_V7 — Wed, 24 Feb 2016 08:01:17 GMT

Hi,

Are you asking in the Value list or What !

Re: grouping qlikview

Wed, 24 Feb 2016 08:35:55 GMT

we create a inline table like

DIM

like wise

can i create

DIM

'AA'

'BB'

'CC'

Re: grouping qlikview

Wed, 24 Feb 2016 09:09:55 GMT

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

Re: grouping qlikview

sunny_talwar — Wed, 24 Feb 2016 09:32:02 GMT

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

Re: grouping qlikview

Wed, 24 Feb 2016 10:59:19 GMT

yes in your solution Dim

Re: grouping qlikview

sunny_talwar — Wed, 24 Feb 2016 11:03:32 GMT

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.

Re: grouping qlikview

Wed, 24 Feb 2016 12:48:55 GMT

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

Re: grouping qlikview

Thu, 25 Feb 2016 10:19:43 GMT

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