qliksense column header to rows

[anirudhrao92]

Hi,

can we change column headers in qliksense straight table to row headers 

i want some thing like this in qliksense 

staright table Actual

City	sales
adb	23
nrl
kkr	22
	34
blr	45

Desired result

	Sum	count of Nulls
city	4	1
Sales	124	1

is it possible in Qlik sense ?

Thanks in Advance

[Channa · Accepted solution]

this will do for you

table1:
LOAD
City,
sales
FROM [lib://TEST/table.xlsx]
(ooxml, embedded labels, table is Sheet1);

Tabke2:
load
'Sumofsales' as DIM,sum(sales) as Totalsale,Sum(if(isnull(sales) OR Len(Trim(sales)) = 0, 1, 0)) as NULLCOUNT Resident table1 ;

Concatenate

load
'NoofCities' as DIM,Count(City) as Totalsale,Sum(if(isnull(City) OR Len(Trim(City)) = 0, 1, 0)) as NULLCOUNT Resident table1;

[Channa]

take qvf

[tush]

Hi,

     you can use the transpose option to do so,

another solution is like you can do it in data load editor as well

Please check below URL for better understanding :-

https://community.qlik.com/t5/Qlik-Sense-App-Development/How-to-convert-columns-to-rows-in-the-data-...

Thanks

Tushar