Hi, is it possible to create a table like this in Qlikview? I can't seem to get the mechanics down, it seems that if I resolve one solution I run into another problem, and surely I am not the only user who would like to see data in this manner:
|# CREATED BY TYPE||2/5-2/11||2/12-2/18||2/19-2/26||2/27-3/4||TOTALS||% to Total|
mainly I would like to have a Totals Column, and then a % of total column. The Date and Type are dimensions in this chart, with expression being where the #'s come from. Does qlikview allow you to see % as well as TOTAL # at the same time?
These both seem like acceptable answers. Sunny, I found yours to be easier to use, I couldn't manage to get Robin's to work. I don't understand why Qlik's tabular formatting can be such a pain... I think many end users would like to have a TOTAL column and a TOTAL % column for a reference, without having to switch all of their values in fields to %....
there's a "dirty" solution possible without calculated dimension:
You could do a join on the dummy table for building a cartesian product and then you divide every value by the number of fields in the dummy table (in this example 3)... but this will sooner or later lead to mistakes...