I'm a QV rookie, currently building out my first ever report. I'm a bit stuck (in something of a Qlikpickle, if you will).
I've pasted in an excel drawing to build what I'm envisioning.
Yesterday
Trailing 7 Days
Trailing 28 Days
Quarter To Date
Year To Date
#
% of leads
#
% of leads
#
% of leads
#
% of leads
#
% of leads
Total Leads
534,313
100%
550,000
100%
482,212
Leads Attempted
480,882
90%
495,000
90%
433,991
Leads Connected
336,617
63%
346,500
63%
Leads Closed
168,309
32%
173,250
so on...
I've written the expressions for the relevant metrics, displaying them along the Y-Axis of my report. This works great for the first column, but how does one create multi-column tables showing different time periods?
I would think that writing expressions along the X and Y Axes would get me there, but can QV do that? Is there a different way to get there?
I'd ideally like to have percentage sub-columns alongside the raw data for each time period (as shown). Can this be done in QV as well?
