Set analysis problem

[#1]

Hi,

I must calculate stock on two given dates. Set analysis are

Sum({1<Date={"<=$(vFirstDate)"}>}Quantity)

Sum({1<Date={"<=$(vSecondDate)"}>}Quantity)

Both results are always same despite different dates.

Any ideas?

TIA

[Anil_Babu_Samineni]

Can you define variables? Ane can you try from text object with two variables and see how values / Date seems

[#3]

Variables are

LetFirstDate = Today();

Let SecondDate = Today();

Variables in a text box are in numeric format

[Anil_Babu_Samineni]

When you say two variables given Today() then what is the use to make of two set analysis.

Variables in a text box are in numeric format

May be change to Date(Today()) -- It will DD/MM/YYYY Format in qlikview

[#5]

Try this ,working fine for me .

=sum({$<Date={"$(vLastDate)"}>}Stock)

=sum({$<Date={"$(vFirstDate)"}>}Stock)

[sravanthialuval]

Try this

Sum({1<Date={"$(='<=' & $(vFirstDate) & '<=' & $(vSecondDate))"}>}Quantity)

[#7]

That didn't help

Thx anyway

[#8]

I can't use $ qualifier, must be 1 (all)

[#9]

Returns zero values and results must be in two separate columns

[Anil_Babu_Samineni]

So then tell me your business logic to give solution. In fact, your set operator is not that much understand