Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Chris,
Hope you are using the Flower bracket when using set.
Try this:
Count({<[PDR Outcome:] = {'Delivered'}>} [PDR Outcome:])
Thanks,
V.
Try these expressions:
Count({<Rating = {'Delivered'}>} Rating)
Count({<Rating = {'Excelled'}>} Rating)
Count({<Rating = {'Inspirational'}>} Rating)
Hi Chris,
is this what you want?
Count({<Rating = {'Delivered', 'Excelled','Inspirational' }>}[Rating])
Andy
Cheers..that worked on test app; however, we have another field called 'Consider Move' but when trying to adapt expression it doesnt like it..? - guess its because its 2 words...
Count([<:Consider Move = {'Delivered'}>] Consider Move)
Chris
Hi Chris,
you need to apply square brackets around it
Count([<[Consider Move] = {'Delivered'}>] [Consider Move])
Andy
Hi Andrew,
Tried it:
Count([<[PDR Outcome:] = {'Delivered'}>][PDR Outcome:])
Doesn't like it...
Hi Chris,
Hope you are using the Flower bracket when using set.
Try this:
Count({<[PDR Outcome:] = {'Delivered'}>} [PDR Outcome:])
Thanks,
V.
Are there really colons in the field name? Also you have an additional ] after {'Delivered'}>]
Andy
removed colons.
Thanks for your help
Can anyone confirm how to have a column that shows this as % too:
Here is correct expression for number.
({<[PDR Outcome] = {'Delivered'}>} [PDR Outcome])