In-Column subtotals and totals using multiple Date types

[#1]

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!

[swuehl]

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

How IntervalMatch Solved My Profit and Loss Dilemma

[#3 · Accepted solution]

Hi Sam,

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

I hope it helps you get there.

Kind regards,

Nuno

[#4]

Nuno,

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

Thanks,

Sam

[#5]

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

[#6]

Would you paste a picture of your solution?

[#7]

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

[#8]

Sure.

[#9]

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

[#10]

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!