topic Sort in the stack bar in QlikView

Sort in the stack bar

manoranjan_d — Sat, 14 Nov 2015 22:52:27 GMT

Hi all,

I m facing a issue on my stack bar that inside value segments are not sort from low to high.

I've attached the qvw file.

please help me on ythis issue

Re: Sort in the stack bar

MarcoWedel — Sun, 15 Nov 2015 01:08:21 GMT

Hi,

maybe like this?:

hope this helps

regards

Marco

Re: Sort in the stack bar

manoranjan_d — Sun, 15 Nov 2015 07:40:28 GMT

Many thanks macro, but using calculated dimension it will cause complexity issue, so this calculated dimension can be return in load script and then we can the field name in dimension?

Re: Sort in the stack bar

MarcoWedel — Sun, 15 Nov 2015 23:46:38 GMT

Hi,

one solution to create the rank within the script could be:

table1:
LOAD Count,
    Type,
    Country,
    [Data source]
 (ooxml, embedded labels, table is Sheet1);   

table2:
LOAD Sum(Count) as SumCount,
    Type,
    Country,
    [Data source]
Resident table1
Group By Type, Country, [Data source];

Left Join (table2)
LOAD Distinct
    Type,
    Country,
    [Data source],
    AutoNumber(RecNo(),Type&'/'&Country) as RankDataSource
Resident table2
Order By Type, Country, SumCount;

Left Join (table1)
LOAD Type,
    Country,
    [Data source],
    RankDataSource
Resident table2;

DROP Field SumCount;
DROP Table table2;

hope this helps

regards

Marco

Re: Sort in the stack bar

manoranjan_d — Tue, 17 Nov 2015 14:00:32 GMT

Many thanks Macro, But i m facing one more issue that is, if the stack bar share 50-50 values then the stack bar is showing as single stack bar not as segregated data in the stack bar. can u help me on this

example:

if the 5 th stack bar have value of 200000 and 200000 then i geting as single stack bar of as 200000. but i need as two data has to be segregated

Re: Sort in the stack bar

MarcoWedel — Wed, 18 Nov 2015 00:54:47 GMT

can you please post your application showing this behaviour?

thanks

regards

Marco

Re: Sort in the stack bar

manoranjan_d — Wed, 18 Nov 2015 15:46:07 GMT

Kindly see the attached file of the 5 the stack bar

Re: Sort in the stack bar

MarcoWedel — Wed, 18 Nov 2015 23:21:38 GMT

Hi,

using the script based rather than the calculated dimension solution, I get:

hope this helps

regards

Marco