Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
anirudhrao92
Not applicable

qliksense column header to rows

Hi,

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

i want some thing like this in qliksense 

staright table Actual

Citysales
adb23
nrl 
kkr22
 34
blr45

 

Desired result

 Sum count of Nulls
city41
Sales1241

 

is it possible in Qlik sense ?

 

Thanks in Advance

1 Solution

Accepted Solutions
Channa
Not applicable

Re: qliksense column header to rows

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
3 Replies
Channa
Not applicable

Re: qliksense column header to rows

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
Channa
Not applicable

Re: qliksense column header to rows

take qvf

Channa
tushar_030
Not applicable

Re: qliksense column header to rows

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