Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Champion III
Champion III

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
Champion III
Champion III

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

Chanty4u
Champion III
Champion III

is this?

add    "=" symbol before the variable while creating

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