topic Re: Stacked Expressions as Rows in Chart in QlikView

Stacked Expressions as Rows in Chart

Mon, 17 Feb 2014 18:03:06 GMT

I really don't think there is a way to do this without a third party reporting tool like NPrint but I thought I would ask anyway just in case. Looing for a creative way to do the following, any help is greatly appreciated!

Sample Date:

Person Sales Qty Month

Bob 100 1 Jan

Sue 200 4 Feb

Bob 50 3 Jan

Fred 75 2 Mar

Sue 35 5 Jan

Desired Chart Result:

Jan Feb Mar

Bob Qty 4 0 0

Sales 150 0 0

Sue Qty 5 4 0

Sales 35 200 0

Fred Qty 0 0 2

Sales 0 0 75

Total Qty 9 4 2

Sales 185 200 75

Re: Stacked Expressions as Rows in Chart

maxgro — Mon, 17 Feb 2014 18:09:45 GMT

with a pivot?

Re: Stacked Expressions as Rows in Chart

albertovarela — Mon, 17 Feb 2014 18:15:50 GMT

Yes, it can be done. Look at the attached QVW

Re: Stacked Expressions as Rows in Chart

Mon, 17 Feb 2014 18:33:38 GMT

Thanks, I have done this before with a pivot, I was just trying to have it export to Excel more cleanly but I can probably just have them print directly from QV instead. Although I WISH there was an option in QV to somehow export a Piviot to Excel and hide duplicate values in dimensions. Might be tough but would be nice.

Re: Stacked Expressions as Rows in Chart

Nicole-Smith — Mon, 17 Feb 2014 21:10:44 GMT

Not that this has much to do with your question, but...

If you were to export a pivot table to Excel and have it not repeat the values, you wouldn't be able to use filtering in Excel like you would expect because there wouldn't be any values in every cell for the column. You would just get the first row that has the actual value in the cell. I'm guessing that is why QV exports tables with values in every cell.

Re: Stacked Expressions as Rows in Chart

Tue, 18 Feb 2014 15:02:15 GMT

Of course. However, for someone needing nice looking information in PDF to distribute to management, the format does not work and requires manual clean up. QlikView leave a lot to be desired in the report formatting area, but that is a different topic. What QV does, it does fantastic!