topic Re: YTD & LYTD? in QlikView

YTD & LYTD?

prajapatiamar38 — Fri, 17 Jul 2015 04:42:16 GMT

Hi experts..,

i want to find out max and max(,2) for ytd and lytd from the follwing field

MOP_FY

F10

F11

F12

F13

F14

F15

F16

When i use max(MOP_FY) It gives NULL output because of that F in field value...

i want to find out max value= F16

second max value=F15
PLZ HELP ME...

Re: YTD & LYTD?

tresB — Fri, 17 Jul 2015 04:47:21 GMT

FirstSortedValue(MOP_FY, -Purgechar(MOP_FY,'F'))

FirstSortedValue(MOP_FY, -Purgechar(MOP_FY,'F') , 2)

Re: YTD & LYTD?

prajapatiamar38 — Fri, 17 Jul 2015 04:56:33 GMT

hie,

i had check ur expression..i had try it in text object..it give null output..
not working.

Re: YTD & LYTD?

tresB — Fri, 17 Jul 2015 04:59:32 GMT

Working with me. PFA

Re: YTD & LYTD?

prajapatiamar38 — Fri, 17 Jul 2015 05:06:50 GMT

hie..
sorry but i had copy the same expression in my application..
it gives null value...
is there any other way...?

i had try maxstring function..
maxstring(mop_fy) i got F16
but for F15 what to do?

Re: YTD & LYTD?

tresB — Fri, 17 Jul 2015 05:17:29 GMT

Best way - share your sample qvw.

Re: YTD & LYTD?

prajapatiamar38 — Fri, 17 Jul 2015 05:42:10 GMT

hie,

sorry my qvw is large in size.
not able to send...

plz help me other way...

and ur qvw gives error on selection,,
jst chk it

Re: YTD & LYTD?

tresB — Fri, 17 Jul 2015 08:29:54 GMT

Check Preparing examples for Upload - Reduction and Data Scrambling

Amarnath Prajapati wrote:

....

and ur qvw gives error on selection,,
jst chk it

If you select one value, you would get output for the first (max) expression and there is no second value in the scope , so no output for second max value. Hope, that makes sense. I.e. you have to select at least two values to make both the expressions work.

If your field values have unwanted blanks, you might try something like:

FirstSortedValue(MOP_FY, -Num(Purgechar(MOP_FY,'F')))

FirstSortedValue(MOP_FY, -Num(Purgechar(MOP_FY,'F')) , 2)