Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
swuehl
MVP
MVP

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

How IntervalMatch Solved My Profit and Loss Dilemma

Not applicable
Author

Hi Sam,

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

I hope it helps you get there.

Kind regards,

Nuno

Not applicable
Author

Nuno,

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

Thanks,


Sam

Not applicable
Author

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
Author

Would you paste a picture of your solution?

Not applicable
Author

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

Not applicable
Author

Sure.table.PNG

Not applicable
Author

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

Not applicable
Author

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!