topic Re: multiple measure columns in a report in QlikView

multiple measure columns in a report

qlikviewwizard — Sat, 25 Apr 2015 06:35:09 GMT

Hi All,

I have different products like p1,p2,p3,p4,p5,p6 and so on....

If I select p1 product, report should show 3 measure columns like p1Actual,p1 Budget, p1%

If I select p2 product, report should show 6 measure columns like p1Actual,p1 Budget, p1%,p2Actual,p2 Budget, p2%.

If I select pn product, report should show n+1 measure columns like pnActual,pn Budget, pn%,pn+1 Actual,pn+1 Budget, pn+1 %.

EMPNO	ENAME	JOB	MGR	HIREDATE	p1 Actual	p1 Budget	p1 %	p2 Actual	p2 Budget	p2 %
1	ENAME1	CLERK	ENAME11	20130112	1100	5000	22	1100	4500	24.44444
2	ENAME2	SALESMAN	ENAME3	20110220	1600	5000	32	1600	4500	35.55556
3	ENAME3	MANAGER	ENAME8	20110501	2850	5000	57	2850	4500	63.33333
4	ENAME4	MANAGER	ENAME8	20110609	2450	5000	49	2450	4500	54.44444
5	ENAME5	ANALYST	ENAME7	20111203	3000	5000	60	3000	4500	66.66667
6	ENAME6	CLERK	ENAME3	20111203	950	5000	19	950	4500	21.11111
7	ENAME7	MANAGER	ENAME8	20110402	2975	5000	59.5	2975	4500	66.11111
8	ENAME8	PRESIDENT	NULL	20111117	5000	5000	100	5000	4500	111.1111
9	ENAME9	SALESMAN	ENAME3	20110928	1250	5000	25	1250	4500	27.77778
10	ENAME10	CLERK	ENAME4	20120123	1300	5000	26	1300	4500	28.88889
11	ENAME11	ANALYST	ENAME7	20121209	3000	5000	60	3000	4500	66.66667
12	ENAME12	CLERK	ENAME5	20101217	800	5000	16	800	4500	17.77778
13	ENAME13	SALESMAN	ENAME3	20110908	1500	5000	30	1500	4500	33.33333
14	ENAME14	SALESMAN	ENAME3	20110222	1250	5000	25	1250	4500	27.77778

How to achieve this?

Thanks in advance.

Re: multiple measure columns in a report

Sat, 25 Apr 2015 09:04:27 GMT

you need to play around with Hide\Show of columns based on the variables or Get current selected value for the field Product.

Re: multiple measure columns in a report

marcus_sommer — Sat, 25 Apr 2015 16:02:59 GMT

I think you could use a normal pivot with your five vertical dimensions and the product-dimension and your measures draged you horizontally to the top left from the pivot. But the width from the chart will be by more than 4/5/6... products not really practical ...

- Marcus

Re: multiple measure columns in a report

qlikviewwizard — Mon, 27 Apr 2015 04:32:56 GMT

Any answers please?

Re: multiple measure columns in a report

marcus_sommer — Mon, 27 Apr 2015 09:56:29 GMT

Have you tried my suggestion?

- Marcus

Re: multiple measure columns in a report

qlikviewwizard — Mon, 27 Apr 2015 13:11:53 GMT

Could you help me to provide qvw, please.

Thanks in advance.

Re: multiple measure columns in a report

marcus_sommer — Mon, 27 Apr 2015 13:48:32 GMT

You need only to drag the dimensions/expression to this place that you want - left-mouse-key click and press on the dimension/expression-header and then drag them and a blue-line appeared showing where you are. If it's not worked have a look on the tab presentation - there is an option to enable/disable the feature.