Discussion Board for collaboration related to QlikView App Development.
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.
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
Thank you Aron..that was perfect
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
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).
Then you can select Ascending or Descending.
Hope that helps.
That was a perfect solution.