topic Re: Qliks in App Development

Qliks

marco_puccetti — Thu, 16 Feb 2017 10:26:09 GMT

Hello, is it possible to create tables with the column names as left row list as in the following sample?

This is the state of the art

| Column A | Column B | Column C |

| VAL A | VAL B | VAL C |

This is what i want to get

| Column A | VAL A |

| Column B | VAL B |

| Column C | VAL C |

Thanks

Marco

Re: Qliks

vikasmahajan — Thu, 16 Feb 2017 10:30:25 GMT

you can use cross table for the same refer demo

Vikas

Re: Qliks

kaushiknsolanki — Thu, 16 Feb 2017 10:30:45 GMT

Hi,

Try Crosstable function.

Crosstable ‒ Qlik Sense

Regards,

Kaushik Solanki

Re: Qliks

Chanty4u — Thu, 16 Feb 2017 10:31:15 GMT

use cross table

crosstable (Column, Value)

Re: Qliks

marco_puccetti — Thu, 16 Feb 2017 10:38:00 GMT

And how can i use it within a Pivot table?

Thanks

Marco

Re: Qliks

kaushiknsolanki — Thu, 16 Feb 2017 10:41:20 GMT

Hi,

The solution which are given by many here i.e of Crosstable can't be used in Pivot, It has to be done in Script.

Regards,

Kaushik Solanki

Re: Qliks

marco_puccetti — Thu, 16 Feb 2017 10:46:05 GMT

In specific, i have different misures (set analysis formula) that need to be expressed in a single column by different rows, of a pivot table.

So what could be a possible solution to this?

Thanks

Marco

Re: Qliks

Thu, 16 Feb 2017 14:05:54 GMT

There's probably a better, less messy way without tmp fields but here you go 1 solution:

Table:
load * inline [
'Column A','Column B','Column C'
'VAL A','VAL B','VAL C'
];


CrossTableData:
Crosstable ("Column 1","Column 2")
Load '' as tmp,"Column A","Column B","Column C" Resident Table;
drop field tmp;
drop table Table;

Re: Qliks

marco_puccetti — Thu, 16 Feb 2017 15:37:42 GMT

I think to Which is the best manner to use it in a pivot table?

Thanks

Marco