Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

add a target on the pivot table

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

see attached.

dwdd.PNG

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

20 Replies
pradosh_thakur
Master II
Master II

did it work for you?

Learning never stops.
n1ef5ng1
Creator
Creator
Author

Thanks for the answer.

however i realized that it doesnt work if i have another dimension (say Continent) and each of the continent have their own sales target.

i tried to use pick and if (continent = 'asia','30',if(continent = 'antartica','100',.......~~~ but it crashes the whole QV

techvarun
Specialist II
Specialist II

Check the attached,

Continent Added

pradosh_thakur
Master II
Master II

it will work. the trick here lies with dim . update the .qvw with continent data. will do it and post again .

edit:

the same is already updated  by varun with continent added.

you have to increase the dim to the number of dimension you are adding. It was 2 before and now  3. modify the set analysis a little bit and it will work.

check the above QVW posted by varun.

regards

Pradosh

Learning never stops.
n1ef5ng1
Creator
Creator
Author

my continent is not a hard coded field and is on my dimension.

by using that i might have two dimensions with same continent...

like my field should have

Dimension : Date and Continent

Expression : sum(Amt) by country

target is by continent, it should read the dimension input of continent and display the target

pradosh_thakur
Master II
Master II

kindly post the QVW.  Let me try and get back to you.

regards

Pradosh

Learning never stops.
n1ef5ng1
Creator
Creator
Author

See attached

dwwd.PNG

i know it doesnt make sense for continent, maybe say.... product? product of the item... Asia should be Toy and Other should be Fashion. each of the product category should have individual target

pradosh_thakur
Master II
Master II

hi

please find the updated data with product added and same is done to the qvw.

the only change you need to do is drag the product column in its proper place by pressing ctrl+shift.

regards

Pradosh

Learning never stops.
n1ef5ng1
Creator
Creator
Author

thanks! are you able to make it that Product A Target is 30 and Product B target is 50. that will solve my problem.

pradosh_thakur
Master II
Master II

Hi

Find the attached.

now the value are 30 and 50 for A and B . If you have any specific value you can add that in the data model and associate it as well.

regards

Pradosh

Learning never stops.