topic Re: Creating an empty column in a straight chart table? in QlikView

Creating an empty column in a straight chart table?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create an empty column in a straight chart table.

I tried this tip from the community:

=''

But it interferes with the set analysis, because the other columns will now display all available data regardless of their set analysis filtering.

Thanks,

Markus

Re: Creating an empty column in a straight chart table?

varshavig12 — Mon, 13 Jun 2016 08:43:55 GMT

I am not sure.

But you can try this.

chr(10)

Re: Creating an empty column in a straight chart table?

varshavig12 — Mon, 13 Jun 2016 08:51:20 GMT

In calculated dimension:

chr(10)

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 08:54:54 GMT

Not sure of the purpose of the empty column, but have you tried adding an expression "=0"? Then change the text colour to match the background.

Good Luck,

Pravesh

Re: Creating an empty column in a straight chart table?

tresB — Mon, 13 Jun 2016 08:55:16 GMT

Try expression like: =Only({<Same set analysis in other expression>} '')

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 08:56:54 GMT

The purpose is to be able to export a certain predefined Excel report, which must include an empty column. So It won't work with zeros.

Re: Creating an empty column in a straight chart table?

muthukumar77 — Mon, 13 Jun 2016 09:03:07 GMT

Hi,

You can use CHR(10) in expression.

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 09:04:08 GMT

Perhaps =text(' ') ?

Re: Creating an empty column in a straight chart table?

varshavig12 — Mon, 13 Jun 2016 09:11:39 GMT

Calculated dimension:

Chr(10)

You can drag this column to left or right as per your requirement in excel, it will not disturb your set analysis expression.

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 09:12:19 GMT

Yes, thank you very much! This works fine.

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 09:13:22 GMT

Thanks, but it gives the same problem (bypasses set analysis) as =''

Re: Creating an empty column in a straight chart table?

vikasmahajan — Mon, 13 Jun 2016 09:23:12 GMT

Re: Creating an empty column in a straight chart table?

Mon, 13 Jun 2016 09:39:01 GMT

Thanks, I never got around to try this, since CHR(10) seemed easier. So your solution might also work.

Re: Creating an empty column in a straight chart table?

muthukumar77 — Mon, 13 Jun 2016 16:36:13 GMT

Yes, That's one of the way.