topic How to handle variable with string in format 2015/01 ? in QlikView

How to handle variable with string in format 2015/01 ?

fredericvillemi — Fri, 23 Jan 2015 08:24:25 GMT

Hello,

i have an issue with variables.

I have a string in which i'm using month formatted like that "yyyy/mm" for example 2014/12

I want to use this set analysis : =sum({<MY_STR_MONTH={$(=maxString(MY_STR_MONTH))}>} value)

to get the sum only for the max month.

But it doesn't work because the $(=MaxString(MY_STR_MONTH)) convert this and the result is 167,8333

How can i do to use the max of a string field in which there is a "/" in a set analysis ?

Thanks

PrashantSangle — Fri, 23 Jan 2015 08:26:31 GMT

Hi,

use Date(MY_STR_MONTH,'YYYY/MM')

Regards

alexandros17 — Fri, 23 Jan 2015 08:27:13 GMT

During loading of your data add another field formatted as YYYYMM and use this for your expressions

fredericvillemi — Fri, 23 Jan 2015 08:37:42 GMT

Oh sorry i have found the good answer in another thread.

sum({<MY_STR_MONTH={'$(=MaxString(MY_STR_MONTH))'}>} VALUE)

I think it's the best answer because i don't have to convert in Date nor to change my loader.

But yes, both other answers were interesting.

Thanks