topic Re: Rearrange row in a straight table in QlikView

Rearrange row in a straight table

qvhjenvo — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table for ex. below

So I want to rearrange so that a new table:

Some ideas to help?

Thanks in advance

arthur_dom — Fri, 18 Mar 2016 14:13:34 GMT

In layout or scripting?

Fri, 18 Mar 2016 14:17:54 GMT

Hi,

It looks like ledger_prospect_date is a dimension in your straight table. Please tick the check-box 'suppress when value is null' for it.

alexdataiq — Fri, 18 Mar 2016 22:43:35 GMT

Asuming that the dashes "-" are null/missing values in your data you could maybe do something in scripting:

I attached a little example.

Regards.

MarcoWedel — Fri, 18 Mar 2016 23:43:21 GMT

Hi,

instead of correcting your straight table you might wish to correct your data model.

Can you provide your script and some sample data to test alternatives?

thanks

regards

Marco

qvhjenvo — Mon, 21 Mar 2016 07:51:25 GMT

Hi, Arthur

For in layout.

I am interested for both.

qvhjenvo — Mon, 21 Mar 2016 07:54:02 GMT

I can not see your attachment. Can u send it again?

Regards

amayuresh — Mon, 21 Mar 2016 07:58:11 GMT

I am not able to open your application.

Please can you provide sample data and What is Amount1 and Amount2 ?