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

Pivot Table in QlikSense

Dear All,

I have data sample as give below (full sample file attached)

Sample Data

   

1monthStatus3monthStatus6monthStatus12monthStatus
NoChange
NoChange NoChange
NoChange
NoChange NoChange
NoChangeQuitQuit
NoChangeNoChangeReduced

can anybody help in producing pivot table in Qlik Sense like give below. ( I want to use only chart function no any other reformatting of data table in load script since it will change data model. Thanks

Desired Table in QlikSense

.

2 Replies
MVP
MVP

Re: Pivot Table in QlikSense

I have a solution for you built on a straight table by only employing chart functions. Since you don't have a dimension field in the data model when importing the raw data unmodified into Qlik Sense I used the ValueList(...) function to create a synthetic dimension. Then I will have to refer to the exactly the same ValueList in the expressions for the various measures for each time category. Have a look at the attached app.

2017-08-12 14_42_54-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png

2017-08-12 14_43_48-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png

2017-08-12 14_44_31-_qc 271025 - pivot - My new sheet _ Data manager - Qlik Sense.png

Not applicable

Re: Pivot Table in QlikSense

Hi Petter,

Thanks for the solution. Can I have QVF attached. I have synthetic dimension and used the expression for measure. But I couldn't get it how did you procued 1m/3/m/12/ etc in columns. Thanks

Community Browser