Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pivot Table Expression

Hi, I have attached the scenario which i want to try doing in Qlikview.

Is this possible in qlikview?

Am getting the chart as in sheet named current output.

Can some one explain me how to get the result as in sheet Expected Result.

Message was edited by: Abirami Rajendran I have added a sample data in the Data.xlsx in Raw Data Tab.

Tags (1)
8 Replies
Not applicable

Re: Pivot Table Expression

Can someone help me out on this..

mightyqlikers
Contributor III

Re: Pivot Table Expression

hi sagar,

could you please create sample data in excel and post.    

pamaxeed
Contributor III

Re: Pivot Table Expression

Please as sam mentioned to help you, you should provide us sample data...

Regards,

Patric

Not applicable

Re: Pivot Table Expression

Please find the attachment of my post.. I have provided the sample data...

mightyqlikers
Contributor III

Re: Pivot Table Expression

not that sagar,

actual data in excel format.    

Not applicable

Re: Pivot Table Expression

I have added a part of the data in the Raw Data tab in my post now.

Not applicable

Re: Pivot Table Expression

The raw data is added in data.xlsx file now.

pamaxeed
Contributor III

Re: Pivot Table Expression

Hope this helps, see attached.

Cheers,

Patric