# QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

New Contributor

## Need help on creating a chart

Hello,

I am trying to create a chart in QV with "Min_Received_Time" as my X-axis, and "Median_Price" as my Y-axis. Can you help me to figure out how I can build this chart?

Here is an example of my raw data table:

 ReceivedTime Kit ID Lot # Price 6/12/16 19:00 1 123-A 850 6/12/16 19:03 2 123-A 800 6/12/16 19:04 3 123-A 900 6/12/16 19:38 4 123-A 850 6/13/16 3:44 5 650-A 750 6/13/16 3:48 6 650-A 825 6/13/16 3:50 7 650-A 825 6/13/16 3:51 8 650-A 900 6/13/16 19:20 9 125-A 900 6/13/16 19:21 10 125-A 900 6/13/16 19:23 11 125-A 800 6/13/16 19:34 12 125-A 900 6/13/16 19:35 13 125-A 1000 6/14/16 3:38 14 220-A 1000 6/14/16 3:39 15 220-A 990 6/14/16 3:40 16 220-A 1100

Then, I would like to group by Lot #, and calculate the Minimum Received Time and Median Price for each Lot #, as show in the table below:

 Lot # Min_Received_Time Median_Price 123-A 6/12/16 19:00 850 650-A 6/13/16 3:44 825 125-A 6/13/16 19:20 900 220-A 6/14/16 3:38 1000

So, the output I want to have is a chart with Min_Received_Time as my X-axis, and Median_Price as my Y-axis. And the input is the raw data. Can anyone help me to figure out how to do this?

Thanks,

Yolanda

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Need help on creating a chart

Use as calculated dimension

and as expression

=Median([Price])

2 Replies
MVP

## Re: Need help on creating a chart

Use as calculated dimension