Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Dimension Calculation

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.

6 Replies
MVP
MVP

Re: Dimension Calculation

Reload the apps and give as an attachment!

Not applicable

Re: Dimension Calculation

your qvw has no data loaded into it

saurabh5
Contributor II

Re: Dimension Calculation

qvw seems to have no data.

Not applicable

Re: Dimension Calculation

I reattached the dashboard.  Sorry about that.

Not applicable

Re: Dimension Calculation

I reloaded the data.  Sorry about that

Not applicable

Re: Dimension Calculation

I reloaded the data.  Sorry about that.