Discussion Board for collaboration on QlikView Scripting.
I attached a QVW that contains my test data.
I want to crate a straight table that tells me how many employees had X number of sales over a date range (weeks). Example of table below...
Sale Count Employee Count AVG Sale Total
1 21 $35
2 18 $28
3 19 $34
4 15 $25
5+ 10 #16
I have a unique key for each transaction/Sale. I believe I need to create a calculated dimension using that unique sale key.
Any help would greatly be appreciated.
Thanks in advance.
Reload the apps and give as an attachment!
your qvw has no data loaded into it
qvw seems to have no data.
I reattached the dashboard. Sorry about that.
I reloaded the data. Sorry about that
I reloaded the data. Sorry about that.