Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gowthamram
Contributor
Contributor

QlikSense pivot table challenge

Hi,

Need help in creating a pivot table in QlikSense.

Input data:

Capture.PNG

Output in Qliksense Pivot table should be like below:

Capture2.PNG

How to achieve this in Qliksense pivot table?

-GDK

3 Replies
felipedl
Partner
Partner

Just loading the data and creating a pivot table with two dimensions and 1 measure should do it Gowtham.

See the attached QVF file for an example (copy it to C:\Users\<user.name>\Documents\Qlik\Sense\Apps if you're in Qlik Sense Desktop to view it),

Felipe.

gowthamram
Contributor
Contributor

Thanks Felip.

But my requirement is that i shouldn't show that measure column as you have given 1.

Output in the pivot table only should have two fields i.e. Capital and State.

-GDK

felipedl
Partner
Partner

I see, well propably some extension could do it.

But a simple table won't have this "aggregation" factor your looking for, since it will get the different lines.

You could do some treatment on the table, so that the values for the same capital appear in the same row, like this:

X:

Load

    Concat(State,', ') as Col1,

FirstValue(Capital) as Col2

Resident data

Group by Capital;

Giving the "Field creation" table bellow:

Sample.png