add a target on the pivot table

[n1ef5ng1]

is it possible to add a target (customized column) on pivot table in qlikview.

see attached.

i would like to add a hard coded 'target' in between Date and the city.

do note that i designed in a way that i need > 1 expression in the table. (i could have add city on dimension and expression to be sum(sales) but it doesnt work in this way).

let me know if it makes sense

[n1ef5ng1]

any body? i am stucked in this for weeks ;(

[nehasaxena]

Why you cant add a third expression in pivot table as target. It should work.

BR,

Neha

[n1ef5ng1]

cant....

[balar025]

Hello Ben,

Please find attached application.

[techvarun]

Try the attached

[n1ef5ng1]

apology everyone, i should stated it clearly on what i need. but i feel is getting there.

please see the image on the expected output that we need.

[techvarun]

check the attached

[n1ef5ng1]

thanks varun. i understand the idea and appreciate it. however my data model are quite complex to add in two rows on target to the data... is there any other way to do on not impacting the data model / excel sheet.

[pradosh_thakur]

Hi

Please find the attached

i have done that using pick function. Let me know if you need anything.

regards

Pradosh