topic ColumnNo() as horizontal Dimension in QlikView

ColumnNo() as horizontal Dimension

jordicastilloga — Sat, 16 Nov 2024 20:34:46 GMT

Hi,

I'm trying to build a pivot table with two dimensions:

- Dimension 1: vertical with a ValueList.

- Dimension2: horizontal with the Customer Code. But, instead of the Customer Code, I want the column number as a header. So the dimension I think I should use is something like this: dual(ColumnNo(),Customer_Code).

Unfortunately, its not working.

Does anyone know how to do it?

Thanks!!!

Jordi.

Re: ColumnNo() as horizontal Dimension

sunny_talwar — Wed, 26 Jun 2019 11:55:23 GMT

How about this?

Aggr(Dual(RowNo(), Customer_Code), Customer_Code)

Re: ColumnNo() as horizontal Dimension

jordicastilloga — Wed, 26 Jun 2019 12:34:03 GMT

Thank you very much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! It works!!!!!