need help

[#1]

hi, how can i write this in chart expression?

SELECT (amQty) FROM FCTRAN WHERE substri(FCTRANSIT,1,1)='S' and substri(FCTRANSIT,1,1)='M'

[vikasmahajan]

better while loading  make flag S & M

and use in set analysis like following

sum( {$< Fiscal Year={$(=max(FiscalYear))}, flag={'S'}  amQty )

Hope this helps you.

Vikas

[#3]

hi vikas,

it s not clear. pls explain. thanks

[vikasmahajan]

Dear Dushan,

In sql script only while taking data from sql  create flag S or M

load this in qlikview

apply set anlysis sum( {$< flag={'S'}  amQty )

This way you can achieve the same.

Vikas

[jagan]

Hi,

Try like this

=Sum({<FCTRANSIT={'S*', 'M*'}>}amQty)

Regards,

Jagan.

[#6]

thanks jagan. it s working. but my full query is like this. Can i do that?

=Sum({<site={'S*', 'M*','SAM*','SML*','MBO*'}>}amQty)

and also i want to get this data in MONTH='11'

help pls

[#7]

Hi Dushan ,

Sum ( {<Mid(FCTRANSIT,1,1) ={'S' , 'M'}>} amQty)

It works ..

Regards,

Koti reddy

[manideep78]

Include Month in same expression

=Sum({<site={'S*', 'M*','SAM*','SML*','MBO*'}, Month={11}>}amQty)

[#9]

Hi Manideep, I applied it but got the same answer without month filtering. why is that?

[#10]

=Sum({<site={'S*', 'M*','SAM*','SML*','MBO*'}>}amQty)

=Sum({<site={'S*', 'M*'}>}amQty)  Returns same  Values

Becoz S* results SAM* ,SML*   also 

for Second Check Whether There Is A relation between

  .. Check out Whether there is a Site and Month ..

If there is relation then it will not Return Same for =Sum({<site={'S*', 'M*','SAM*','SML*','MBO*'}, Month={11}>}amQty)

and above..

If there is no relation it will return same..