Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

set analysis

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

7 Replies
Chanty4u
MVP
MVP

try this

for all

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

sergio0592
Specialist III
Specialist III

Try with :

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

manoranjan_d
Specialist
Specialist
Author

not working getting over all sum of usd medium

manoranjan_d
Specialist
Specialist
Author

not working getting error

tresesco
MVP
MVP

Could you share a sample qvw?

Chanty4u
MVP
MVP

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

Chanty4u
MVP
MVP

is this?

add    "=" symbol before the variable while creating

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