Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
taherk
Contributor
Contributor

max value of column A which has value x in column B

Dear all,

I Have just started learning a great tool Qlik sense Desktop. I need to display Maximum and Minimum value of temperature of Devices. Im having 3 column Devices, Timestamp, Temperature

Devices, Timestamp, Temperature

Device1,16-04-2019 1:30:45,25

Device2,16-04-2019 2:30:45,23

Device2,16-04-2019 3:30:45,21

Device2,16-04-2019 4:30:45,26

Device1,16-04-2019 5:30:45,27

Device1,16-04-2019 6:30:45,22

 

I want to display Max/Min Temperature of Device1 and Device2.

Kindly help me with that. 

Thanks in advance

Labels (1)
  • SaaS

1 Reply
emrekaya
Contributor III
Contributor III

How do you wanna show those max and min temperatures of the devices? If a simple table is enough, you can use devices as dimension and you can create two columns as measure, one of them is max(temperatures) and the other one is min(temperatures).