Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Im kinda new to Qlikview, done basic training in Stockholm.
My question or my problem consist of.
I try to make a chart that shows quality kitchen percentage in a chart with top ten salesman.
qualitykitchen is a variabel with 1 or null.
orderId is the other variabel im that is unique for all orders.
So when i do my selection qualitykitchen :
I can see the total amount of qualitykitchen the top salesman has made, but its not representative though it doesent take in consider how many kitchen they sold. So i would like to make an expression that divide qualitykicthen with amount sold kitchen. That would give me a percentage that is representative.
But i dont seems to be able to create that.
Anyone that can point me in the right direction?
Thx in advance and sorry for the bad spelling.
/André
Can you post a sample
ive tryed count(qualitykitchen) / count(OrderId2)
since i dont know how tu use set analysis, ive made to sets of the script where qualitykitchen is selected in the first script (selection) and in the 2nd ive havent made any selection, that would show the alla kitchen with whether they are qualitykitchen or not. to be able to make selections work. But i dont get why the result is not correct.
the dimesion ive used is salesman.