Hi,
Please refer to attached app.
Common issue were trying to overocome is changing the axis on a pivot table.
On the attached you will see some data. We want this to appear on the pivot table atatched labelled ' format we want to work' where the rating is the x axis and the area is the y. Whilst visually it looks like its working there is errots with the data as it is showing the same values for each option. I,' assuming this is because of the expression which is as follows
([Rating]= 'Delivered')
Qlikview says ;'expression ok' (and it makes sense) but we know this is incorrect because when you revert to the standard way Qlikviewo presents data (see table entitled 'how currenrtly works') the numbers are correct.
It's mad but what were trying to do is really easy in pivot tables functionality in excel but we would prefer not doing the all the good work developing an app to then have to export to excel to do any analsyis.
Any help would be greatly apprecieted.
Chris
