Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did it work for you?
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
Check the attached,
Continent Added
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
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
kindly post the QVW. Let me try and get back to you.
regards
Pradosh
See attached
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
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
thanks! are you able to make it that Product A Target is 30 and Product B target is 50. that will solve my problem.
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