topic Re: Expression in HOrizontal Way in QlikView

Expression in HOrizontal Way

pavanthota — Fri, 17 Jun 2016 07:37:47 GMT

I have one dimension called A ,it has multiple values and multiple expressions called B. C and D. I want to show the expressions B, C and D values in row wise based on the Dimension A values. Please find the below example.

XYZ, RTY, UVW, PQR,STU is the Dimension A Values. Dimension A should be converrt as column header that we can do through pivot table.but how to convert expressions row wise.

	XYZ	RTY	UVW	PQR	STU
B	100	300	500	700	600
C	20	30	40	50	78
D	10%	20%	60%	89%	78%

Can you please help me anyone

Re: Expression in HOrizontal Way

swuehl — Fri, 17 Jun 2016 09:25:42 GMT

Use a straight table with your one dimension and three expressions and enable option 'Horizontal' on presentationt tab.

Re: Expression in HOrizontal Way

pavanthota — Fri, 17 Jun 2016 12:51:39 GMT

Hi Swuehi,

Thank you very much for your quick reply

Re: Expression in HOrizontal Way

pavanthota — Fri, 17 Jun 2016 15:54:35 GMT

Hi Swuehi,

One more help i needed from you i need to show row total at the right hand side as a total column can you please help me on that.

Thanks,

Pavan

Re: Expression in HOrizontal Way

swuehl — Fri, 17 Jun 2016 16:33:50 GMT

You should see a total column when you using a total mode with totals for your expressions.

Then select option 'totals on last row' on presentation tab.

Re: Expression in HOrizontal Way

pavanthota — Fri, 17 Jun 2016 17:33:18 GMT

Hi Swuehi,

I tried the option which you mentioned above unfortunately its not working

Re: Expression in HOrizontal Way

pavanthota — Fri, 17 Jun 2016 17:41:14 GMT

Hi Swuehi,

Thanks for Quick reply I am sorry about previous reply option is working now

Re: Expression in HOrizontal Way

swuehl — Fri, 17 Jun 2016 17:46:32 GMT

Could you post a small sample QVW?

Also, it's not working is not a precise issue description.

Does this mean you don't get totals at all or you are not able to move the total column to the right?