topic Re: Table Format and Analysis in QlikView

Table Format and Analysis

Tue, 19 Apr 2016 14:32:03 GMT

Hello to all,

I'm having some issues to make a table in the format of the one in the spreadsheet attach.

Using the pivot table, I can't get the information in this format.

Please note that I have those two fields (Expenses and Budget).

Thanks for your support.

Let me know if you need more information.

Re: Table Format and Analysis

awhitfield — Tue, 19 Apr 2016 14:44:32 GMT

Hi Marco,

can you upload an example QVW?

Andy

Re: Table Format and Analysis

sunny_talwar — Tue, 19 Apr 2016 14:45:15 GMT

What is the issue when you try to create the table in a certain way?

Re: Table Format and Analysis

marcus_sommer — Tue, 19 Apr 2016 14:50:06 GMT

If you want to combine the columns like in the excel then you would need either to use for each an own expression (15) or you need to create Budget - Expenses and Budget as calculated dimensions and could then use month as horizontally dimension.

- Marcus

Re: Table Format and Analysis

Tue, 19 Apr 2016 18:54:48 GMT

Marcus,

Thanks for the solutions proposed. I created one column for each expression and it worked perfectly. If my performance gets affected I'll evaluate if it would be better to use the second solution proposed.

Thanks a lot to all for the answers.