Discussion board where members can get started with Qlik Sense.
can we change column headers in qliksense straight table to row headers
i want some thing like this in qliksense
staright table Actual
is it possible in Qlik sense ?
Thanks in Advance
Go to Solution.
this will do for you
table1:LOADCity,salesFROM [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 ;
load'NoofCities' as DIM,Count(City) as Totalsale,Sum(if(isnull(City) OR Len(Trim(City)) = 0, 1, 0)) as NULLCOUNT Resident table1;
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 :-