Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

Degree Centigrade to Fahrenheit Conversion

Dear All,

Can any one help me with Degree Centigrade to Fahrenheit Conversion ??

I want to show it in Qliksense. Need to give one filter having Value Degree and Fahrenheit.

I have a field of temperature in which i am getting value in Centigrade.

Concern is I have to made a report in QLiksense, since there are no Conditional show how i covert Centigrade to Fahrenheit in Report.

Pls suggest

Regards

Abhay

5 Replies
bismart
Contributor

Re: Degree Centigrade to Fahrenheit Conversion

X Centigrade = (X * 1.8) + 32

20 Centigrade      = (10 * 1.8) + 32

                          = 18 + 32

                          = 50 Fahrenheit

bismart
Contributor

Re: Degree Centigrade to Fahrenheit Conversion

should be

20 Centigrade      = (20 * 1.8) + 32

                          = 36 + 32

                          = 68 Fahrenheit

abhaysingh
Contributor III

Re: Degree Centigrade to Fahrenheit Conversion

Thanks Dave for revert but my concern is not logic ,, concern is how i can toggle it in Qliksesne by selecting filter.

Thanks For revert.

Abhay

balrajahlawat
Esteemed Contributor

Re: Degree Centigrade to Fahrenheit Conversion

As you said, you are having field of Temprature say XYZ.

I guess through following expression you can easily get in Fahrenheit:

Fahrenheit=(XYZ/5)*9+32 as a expression

Hope this will help

bismart
Contributor

Re: Degree Centigrade to Fahrenheit Conversion

Sample app attached

You need to install qsVariable from http://branch.qlik.com/projects/showthread.php?396-qsVariable&highlight=variable

regards

Dave

Community Browser