topic Re: showing string name in qlikview pivot table expression in QlikView

showing string name in qlikview pivot table expression

kishorj1982 — Mon, 04 Dec 2017 04:36:36 GMT

Hi All,

I want to pivot the column and need to show the string name in qlikview pivot table expression.

I am using concat(columnname,'') in pivot table expression.

But all names are not displayed.

Please suggest.

thanks

prma7799 — Mon, 04 Dec 2017 04:46:11 GMT

You can directly put your column name in the expression ....

Please share sample app with expected output.

tresB — Mon, 04 Dec 2017 04:47:03 GMT

Try to share and explain in a sample or screenshot to demonstrate your issue.

Anil_Babu_Samineni — Mon, 04 Dec 2017 05:07:30 GMT

To increase Cell height you need to setting from presentation tab under "Preserve" box you need to increase "Cell Height" from Default to needed

kishorj1982 — Mon, 04 Dec 2017 05:20:41 GMT

PFA.

i have attached the screenshot,I need to show the names as shown in screenshot.But using concat(columnname,'') all names are not displayed.

Thanks

tresB — Mon, 04 Dec 2017 05:26:47 GMT

What expression are you trying and how does the output look like with that?

kishorj1982 — Mon, 04 Dec 2017 05:53:14 GMT

I m using concat(columnname,'') in expression

prma7799 — Mon, 04 Dec 2017 05:59:40 GMT

Expression is ok . Could you please share sample file.

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:00:04 GMT

There is no often to reply here. Just increase the cell height till needed. Is my input won't help for you?

kishorj1982 — Mon, 04 Dec 2017 06:59:02 GMT

Hi anil,

can you please tell me where is this setting in pivot table.

Thanks

prma7799 — Mon, 04 Dec 2017 07:07:54 GMT

Please check