topic Re: set analysis in QlikView

set analysis

manoranjan_d — Thu, 05 Oct 2017 08:07:23 GMT

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 — Thu, 05 Oct 2017 08:10:57 GMT

try this

for all

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

sergio0592 — Thu, 05 Oct 2017 08:29:26 GMT

Try with :

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

manoranjan_d — Thu, 05 Oct 2017 09:31:27 GMT

not working getting over all sum of usd medium

manoranjan_d — Thu, 05 Oct 2017 09:31:45 GMT

not working getting error

tresB — Thu, 05 Oct 2017 09:35:14 GMT

Could you share a sample qvw?

Chanty4u — Thu, 05 Oct 2017 09:35:22 GMT

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

Chanty4u — Thu, 05 Oct 2017 09:38:36 GMT

is this?

add "=" symbol before the variable while creating

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