topic Re: In-Column subtotals and totals using multiple Date types in QlikView

In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 20:41:25 GMT

Hi all,

I'm new to Qlikview and am completely stymied on how to achieve the following:

1) I have no idea if I should start with a pivot table base, or a straight table, or something else.

2) I have no idea how to put QTD and YTD rows interspersed with Months

3) Etc

Thanks!

Re: In-Column subtotals and totals using multiple Date types

swuehl — Wed, 29 Jul 2015 22:06:24 GMT

Please have a look into this blog post and the referenced sample app.

How IntervalMatch Solved My Profit and Loss Dilemma

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 22:14:40 GMT

Hi Sam,

Please see my very simple approach to question on the file attached.

I hope it helps you get there.

Kind regards,

Nuno

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 22:36:30 GMT

Nuno,

Your solution seems to make the chart horizontal rather than vertical. Am I missing something?

Thanks,

Sam

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:31:01 GMT

Hi Sam,

It is a pivot table and maybe the format got lost. Try playing with the dimensions, dragging the horizontal dimensions to the top.

Hope this helps.

Kind regards,

Nuno

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:33:59 GMT

Would you paste a picture of your solution?

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:35:58 GMT

I don't understand what you mean by "dragging the horizontal dimensions to the top."

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:37:45 GMT

Sure.

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:39:20 GMT

This is awesome! But I can't seem to get it to look like that. Mine proceeds out horizontally rather than vertically.

Re: In-Column subtotals and totals using multiple Date types

Wed, 29 Jul 2015 23:45:54 GMT

Is this the same file that you posted before? If not, could/would you post the file that generated this picture, please?

Thanks so much!

Re: In-Column subtotals and totals using multiple Date types

Thu, 30 Jul 2015 08:20:39 GMT

Unfortunately, it's the same file. It looks ok on my Qliview Desktop.

Please whatch this video around minute 6. It will show you how to drag the fields in the pivot table.

QlikView | Pivot Tables - YouTube

Re: In-Column subtotals and totals using multiple Date types

qlikviewwizard — Thu, 30 Jul 2015 08:22:55 GMT

Hi WonderBoy

Can you attach the sample data? It will help the folks to give quick and better solution. Thank You.

Re: In-Column subtotals and totals using multiple Date types

Thu, 30 Jul 2015 21:00:59 GMT

Nuno,

You're a genius! Thanks so much!

Cheers,

Sam