Stacked Expressions as Rows in Chart

[#1]

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

[maxgro · Accepted solution]

with a pivot?

[albertovarela]

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

[#4]

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.

[Nicole-Smith]

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.

[#6]

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!