Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

weiyunyunyy
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 in advance!


Thanks,

Yolanda

1 Solution

Accepted Solutions
MVP
MVP

Re: Need help on creating a chart

Use as calculated dimension

=Aggr( Date(Min(Received_Time)), [Lot #])

and as expression

=Median([Price])

2 Replies
MVP
MVP

Re: Need help on creating a chart

Use as calculated dimension

=Aggr( Date(Min(Received_Time)), [Lot #])

and as expression

=Median([Price])

weiyunyunyy
New Contributor

Re: Need help on creating a chart

THANK YOU, this works perfect!!

Community Browser