topic Re: Need to create a dimension in chart in QlikView

Need to create a dimension in chart

markgraham123 — Thu, 24 Sep 2015 23:42:23 GMT

Hi all,

I'm working on a requirement where i do not have a dimension, but only its values.

For eg: I have Zone1, Zone2, Zone3, and Zone4

I have only numbers in all the 4 fileds.

I did the sum() all the numbers in chart, without dimension, it looks like

Zone1 Zone2 Zone3 Zone4

But i wanna display it like

Zone1

Zone2

Zone3

Zone4

By adding some manual dimension in chart or in script.

Any help will be highly appreciated.

Please find the application attached.

Re: Need to create a dimension in chart

gautik92 — Fri, 25 Sep 2015 06:51:16 GMT

Table1:

LOAD

Sum([Zone1 Units]) as Zone1Units,

Sum( [Zone 2 Units]) as Zone2Units,

Sum( [Zone 3 Units]) as Zone3Units,

Sum([Zone 4 Units]) as Zone4Units

FROM

bookbook.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Need to create a dimension in chart

Digvijay_Singh — Fri, 25 Sep 2015 07:18:44 GMT

This works -

Load * Inline [

Zone1, Zone2, Zone3, Zone4

1,1,1,1

2,2,2,2

3,3,3,3

4,4,4,4

5,5,5,5

];

Dimension - =ValueList('Zone1','Zone2','Zone3','Zone4')

Expression - pick(match(ValueList('Zone1','Zone2','Zone3','Zone4'),'Zone1','Zone2','Zone3','Zone4'),MaxString(Zone1),MaxString(Zone2),MaxString(Zone3),MaxString(Zone4))

Re: Need to create a dimension in chart

Digvijay_Singh — Fri, 25 Sep 2015 07:22:14 GMT

Just checked i req that expression needs sum,like that-

pick(match(ValueList('Zone1','Zone2','Zone3','Zone4'),'Zone1','Zone2','Zone3','Zone4'),Sum(Zone1),Sum(Zone2),Sum(Zone3),Sum(Zone4))

Re: Need to create a dimension in chart

simenkg — Fri, 25 Sep 2015 07:30:00 GMT

Set the "Total mode" under Expressions to No Total.

Under Presentation, check the "Horizontal" checkbox.

Re: Need to create a dimension in chart

markgraham123 — Fri, 25 Sep 2015 14:06:07 GMT

This works exactly Mr. Singh.

This is really genius thing and awesome.

Thanks a ton.

Re: Need to create a dimension in chart

markgraham123 — Fri, 25 Sep 2015 14:07:18 GMT

Hi Mr.Kesavan,

Sum() in the background helped me to get the chart in the right format.

Thank you.

Never knew that we can sum() without any dimension and group by.

Learning lot of things as i'm beginner.

Thank You.

Re: Need to create a dimension in chart

markgraham123 — Fri, 25 Sep 2015 14:08:45 GMT

Hi Mr. Gulbrandesn,

Thank you for your help.

Learnt a new thing that we can use "Horizontal" in the table.

Really inspiring.

Thanks again sir.