Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a table that displays information like this:
Employee | Calls Made | Sales Made | Sales from Calls |
---|---|---|---|
Average | 10 | 4 | 38.61% |
Total | 30 | 12 | --- |
Annie | 10 | 2 | 20.00% |
Bianca | 12 | 7 | 58.33% |
Charlie | 8 | 3 | 37.50% |
This is a simple task in Excel, but I cannot figure out how to do this in Qlik Sense. There are several challenges here:
Check this out and see if this help
Nice solution, that's definitely thinking out of the box!
I am glad you like it
Thank you. I have not had time to fully explore this option, I'll come back with my results.
i have seen sunny doing it quite a few time in the community and i once applied it when all put their hands up and the team has an illusion now that i am the person who thinks out of the box. So passing the credit to you stalwar1.
Well I was not the one who started this (not sure who did), but I learnt this technique from kush141087... so passing along the credit to him
Hi Sunny , It's really a great Stuff !
Can you help in my case. Details are mentioned in attached Excel format where sheet 1 is my input data and my sheet 2 are my expected output with Avg file.
Pls help to achieve this.