please help..pivot table error

[#1]

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

[sunny_talwar]

Try these expressions:

Count({<Rating = {'Delivered'}>} Rating)

Count({<Rating = {'Excelled'}>} Rating)

Count({<Rating = {'Inspirational'}>} Rating)

[awhitfield]

Hi Chris,

is this what you want?

Count({<Rating = {'Delivered', 'Excelled','Inspirational' }>}[Rating])

Andy

[#4]

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

[awhitfield]

Hi Chris,

you need to apply square brackets around it 

Count([<[Consider Move] = {'Delivered'}>] [Consider Move])

Andy

[#6]

Hi Andrew,

Tried it:

Count([<[PDR Outcome:] = {'Delivered'}>][PDR Outcome:]) 

Doesn't like it...

[vishsaggi · Accepted solution]

Hi Chris,

Hope you are using the Flower bracket when using set.

Try this:

Count({<[PDR Outcome:] = {'Delivered'}>} [PDR Outcome:])

Thanks,

V.

[awhitfield]

Are there really colons in the field name? Also you have an additional ] after  {'Delivered'}>]

Andy

[#9]

removed colons.

Thanks for your help

[#10]

Can anyone confirm how to have a column that shows this as % too:

Here is correct expression for number.

({<[PDR Outcome] = {'Delivered'}>} [PDR Outcome])