Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

In-Column subtotals and totals using multiple Date types

Hi all,

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

QlikView Help Pic 7-29-2015.JPG

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!

1 Solution

Accepted Solutions
Not applicable

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

Hi Sam,

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

I hope it helps you get there.

Kind regards,

Nuno

View solution in original post

12 Replies
MVP
MVP

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

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

How IntervalMatch Solved My Profit and Loss Dilemma

Not applicable

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

Hi Sam,

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

I hope it helps you get there.

Kind regards,

Nuno

View solution in original post

Not applicable

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

Nuno,

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

Thanks,


Sam

Not applicable

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

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

Not applicable

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

Would you paste a picture of your solution?

Not applicable

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

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

Not applicable

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

Sure.table.PNG

Not applicable

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

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

Not applicable

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

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!