Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
balrajprabhu
Creator II
Creator II

How to convert 0.25 to 3 months and 0.75 to 9 months?

Hello fellow developers,

I have a list box contaoning values like 0.25,0.75,1,1.50 ....etc they represent years.

I want to display 3 months instead of 0.25

                        6 months instead of 0.50....1 year 6 months instead of 1.50..

How can this be done.

Thanks

B

1 Solution

Accepted Solutions
aaroncouran
Creator III
Creator III

Don't know if this is the MOST elegant way, but a calculated dimension with something like this:

=FLOOR(Period) & ' Years ' & (Period - FLOOR(Period))*12 & ' Months'

That should do the trick.

View solution in original post

5 Replies
aaroncouran
Creator III
Creator III

Don't know if this is the MOST elegant way, but a calculated dimension with something like this:

=FLOOR(Period) & ' Years ' & (Period - FLOOR(Period))*12 & ' Months'

That should do the trick.

View solution in original post

balrajprabhu
Creator II
Creator II
Author

Thank you Aron..that was perfect

balrajprabhu
Creator II
Creator II
Author

For some reason I'm not able to sort the result in ascending or descending order...I want to sort it in ascending order..any suggestions

aaroncouran
Creator III
Creator III

So leave the calculated dimension alone.  Go to the Sort tab and check "Expression".  In the edit box use whatever your field name is (I used "Period" in my example). 

=Period

Then you can select Ascending or Descending.

Hope that helps.

balrajprabhu
Creator II
Creator II
Author

Aron,

That was a  perfect solution.

Thanks

B