topic Re: Bar Chart - Use measure as dimension in QlikView

Bar Chart - Use measure as dimension

qlikviewwizard — Tue, 08 Dec 2015 05:14:56 GMT

Hi All,

I have the Month dimension and 4 measures (Sales,Accounting,Marketing and Finance).

How to use measure as dimension and show the data in bar chart as shown below?

Data:

Load * Inline [

Month,Sales,HR,Accounting,Finance

Jan,80,47,61,19

Feb,78,42,63,19

Mar,72,36,60,17

Apr,73,35,62,17

May,81,42,65,20

Jun,84,40,63,20

Jul,72,35,60,17

Aug,80,40,58,19

Sep,77,45,63,21

Oct,81,42,65,20

Nov,84,40,63,20

Dec,72,35,60,17

];

Thanks in advance.

Re: Bar Chart - Use measure as dimension

jagan — Tue, 08 Dec 2015 05:25:34 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Bar Chart - Use measure as dimension

jagan — Tue, 08 Dec 2015 05:26:17 GMT

Used this script

Data:

CrossTable(Department, Value)

Load * Inline [

Month,Sales,HR,Accounting,Finance

Jan,80,47,61,19

Feb,78,42,63,19

Mar,72,36,60,17

Apr,73,35,62,17

May,81,42,65,20

Jun,84,40,63,20

Jul,72,35,60,17

Aug,80,40,58,19

Sep,77,45,63,21

Oct,81,42,65,20

Nov,84,40,63,20

Dec,72,35,60,17

];

and in chart

Dimension: Department, Month

Expression: Sum(Value)

Hope this helps you.

Regards,

Jagan.

Re: Bar Chart - Use measure as dimension

Anonymous — Tue, 08 Dec 2015 05:28:56 GMT

Nothing to do...

Just take Department & Month as a dimension

and sum(sales) as Measure....

Re: Bar Chart - Use measure as dimension

tresB — Tue, 08 Dec 2015 05:31:35 GMT

PFA

Re: Bar Chart - Use measure as dimension

Kushal_Chawda — Tue, 08 Dec 2015 05:38:16 GMT

Dimensions:

1) ValueList('Sales','Accounts','Finance','HR')

2) Month

Expression :

=pick(match(ValueList('Sales','Accounts','Finance','HR'),'Sales','Accounts','Finance','HR'),

sum(Sales),sum(Accounting),sum(Finance),sum(HR))

Re: Bar Chart - Use measure as dimension

tresB — Tue, 08 Dec 2015 05:47:03 GMT

It seems, you really like this valuelist()/valueloop() functions (seen, you resolving few more issues with them here). However, it is suggested not to use them unless there is no other way at all. Because, as you might know, this method is too non-dynamic; maintenance-costly...

Re: Bar Chart - Use measure as dimension

jagan — Tue, 08 Dec 2015 06:18:22 GMT

Hi,

You can also use ValueList() but it is a kind of hardcoding and complicated process. If the data is huge you will get performance issues.

Regards,

Jagan.

Re: Bar Chart - Use measure as dimension

Kushal_Chawda — Tue, 08 Dec 2015 06:21:19 GMT

Yes, but it is not always the case. If your synthetic dimensions are fixed and amount of data is not so large it is easy to implement. Sometimes developer may not have rights to change the script or script is too complex so instead of doing changes in script developer may need to choose frond end solution.