topic Re: QUERY in QlikView

QUERY

Thu, 09 Jul 2015 07:02:54 GMT

how to sort this in

FW15 ,SS15 AND FW14

WHERE FW AND SS DERIVED FROM

if(YearSeason >= $(vOldYear)and Match(Mid(LocalQuarterSeason,3,2), 'PQ'), if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),'FW','SS')&Left(LocalQuarterSeason,2), 'Older')

Re: QUERY

Anonymous — Thu, 09 Jul 2015 07:11:44 GMT

try in your sortoder the xpression

=match(LocalQuarterSession,'FW15','SS15','FW14','Older')

Re: QUERY

crusader_ — Thu, 09 Jul 2015 07:21:42 GMT

Hi,

Use DUAL in your script:

if(YearSeason >= $(vOldYear)and Match(Mid(LocalQuarterSeason,3,2), 'PQ'), DUAL(if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),'FW','SS')&Left(LocalQuarterSeason,2), 'Older'), NUM(if(Match(Mid(LocalQuarterSeason,4,2), 'Q4','Q3'),2,1)&Left(LocalQuarterSeason,2), 0)) )

Sort by exression is very resource consuming operation.

Hope this helps you.

Regards,

Andrei

Re: QUERY

jagan — Thu, 09 Jul 2015 07:49:25 GMT

Hi Sweta,

Try like this in in your Sort tab expression

=Match(LocalQuarterSession,'FW15','SS15','FW14','Older')

OR load an inline table with required order and select Load Order in Sort Tab.

LOAD

INLINE [

FieldName

FW15

SS15

FW14

Older]

Hope this helps you.

Regards,

Jagan.

Re: QUERY

Thu, 09 Jul 2015 08:06:31 GMT

cant understand your script, it s gives wrong result

expression given by me is calculated dimension

Re: QUERY

Thu, 09 Jul 2015 08:08:22 GMT

find list of local quarter season

FW & SS derived from them

Re: QUERY

jagan — Thu, 09 Jul 2015 08:10:37 GMT

Can you attach sample file?

Regards,

Jagan.

Re: QUERY

Thu, 09 Jul 2015 13:14:22 GMT

can't