topic Re: Calculated Dimension Issue in QlikView

Calculated Dimension Issue

Wed, 25 Nov 2020 16:16:04 GMT

I am facing an issue to create a object.I have a Excel file with sheet names A,B,C as a source file.now i need to create a object based on the sheets like below.

Expected Output:

Please find the attached Sample excel file as reference.

The value 30 under Jan(Period -A) is the sum of values coming from Sheet A Jan values.same way the remaining values

Re: Calculated Dimension Issue

sunny_talwar — Thu, 01 Dec 2016 18:10:22 GMT

So data comes in a form of a pivot table where Months are pivoted? or is this just for demonstration purposes?

Re: Calculated Dimension Issue

Thu, 01 Dec 2016 18:29:32 GMT

Hi Sunny,

Thanks for reply.

Data is not coming in the form of pivot table.its directly fields names with values.

Re: Calculated Dimension Issue

sunny_talwar — Thu, 01 Dec 2016 18:30:26 GMT

Would you be able to share how the actual data is coming?

Re: Calculated Dimension Issue

Thu, 01 Dec 2016 18:39:23 GMT

Attached file is the sample data file.

Please find and let me know if any details required.

Thanks

Re: Calculated Dimension Issue

Anonymous — Thu, 01 Dec 2016 18:45:39 GMT

only periods a,b and c exist?

Re: Calculated Dimension Issue

Thu, 01 Dec 2016 18:50:33 GMT

Yes only periods a,b , c exist.i need to show now total values as a sum under Jan,Feb,Mar......till Dec against Period Dimension and Difference also from total values.

Re: Calculated Dimension Issue

sunny_talwar — Thu, 01 Dec 2016 18:57:12 GMT

Check out the attached

Re: Calculated Dimension Issue

Anonymous — Thu, 01 Dec 2016 19:10:51 GMT

...

Re: Calculated Dimension Issue

Fri, 02 Dec 2016 16:08:25 GMT

Thanks Sunny.Its working fine