topic Re: Straight Table chart..calculated Dimension in QlikView

Straight Table chart..calculated Dimension

pra_kale — Tue, 04 Aug 2015 15:47:43 GMT

Hi,

I have created one straight table with 4 dimensions. My requirement is that I want one another additional dimension which is concatenate of this 4 dimensions. Also I want to give the name to that dimension.

I have tried it by '$' between two columns, but it is not working as I can not give a name to the newly added dimension also I want space between two dimensions names.

Can any one help me in this.

Thanks in Advance.

Re: Straight Table chart..calculated Dimension

ramoncova06 — Tue, 04 Aug 2015 15:49:37 GMT

have you tried using '&' ?

the syntax would be like

dimension1&dimension2&dimension3&dimension4

Re: Straight Table chart..calculated Dimension

pra_kale — Tue, 04 Aug 2015 16:01:56 GMT

Thanks for your reply.

Yes, I have tried it same way, but how to give name to the added dimension as I am getting that formula only at that place as a dimension name...also I want to give space between them. Whether this Two things are possible?

Re: Straight Table chart..calculated Dimension

Tue, 04 Aug 2015 16:11:15 GMT

Type the name you want in the label section. Also if you want a space then it should be, name1& ' '&name2&' '&name3&' '&name4. Thanks

Re: Straight Table chart..calculated Dimension

ramoncova06 — Tue, 04 Aug 2015 16:17:47 GMT

as Srukmana mentioned you need to add a label for any calculated dimension otherwise the label will show the expression being used