Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
enimenas1
Contributor
Contributor

Median for item price

Hi, how can I calculate median for each date for item Gross profit without using Data Load editor and creating new table?

I have table:

trans_no             Unit_price      Unit_cost         Qantity          Date

transactionA       $2                         $1                         5               2020.01.01

transactionA       $4                         $2                         1               2020.01.01

transactionB       $5                         $2                         2               2020.01.01

transactionC      $10                       $6                          1               2020.01.02

So I want to create a measure which calculates Item GP median. In this example it will be $1

$1, $1, $1, $1, $1, $2, $3, $3 $4

 

 

Labels (2)
0 Replies