set analysis

[manoranjan_d]

Hi all,

I have declared an variable

called

vMin=date(min([Comp Date]),'MM/DD/YYYY')

vMax=date(max([Comp Date]),'MM/DD/YYYY')

wheni make set analysis calucaltion for the min and max

its not showing the correcte count below is my expression i tried three ways but not getting the correct result

=sum({<[Comp Date]={'$(vMax)'}>}[USD Medium])

=sum({<[Comp Date]=$(vMax)>}[USD Medium])

=sum({<[Comp Date]={'=$(vMax)'}>}[ Medium])

=sum({<[Comp Date]={"=$(vMax)"}>}[USD Medium])

similar to min date

let me know know solution for my issue thx

[Chanty4u]

try this

for all

=sum({<[Comp Date]={$(=vMax)}>}[USD Medium])

[sergio0592]

Try with :

=sum({<[Comp Date]={"=$(=vMax)"}>}[USD Medium])

[manoranjan_d]

not working getting over all sum of usd medium

[manoranjan_d]

not working getting error

[tresesco]

Could you share a sample qvw?

[Chanty4u]

it should work what error your getting could you please share the screen shot of it?

[Chanty4u]

is this?

add    "=" symbol before the variable while creating

=sum({<[Comp Date]={$(=vMax)}>}[USD Medium])