topic Re: Set analysis problem in QlikView

Set analysis problem

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set analysis problem

Anil_Babu_Samineni — Fri, 17 Mar 2017 09:29:40 GMT

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

Re: Set analysis problem

Fri, 17 Mar 2017 09:45:12 GMT

Variables are

LetFirstDate = Today();

Let SecondDate = Today();

Variables in a text box are in numeric format

Re: Set analysis problem

Anil_Babu_Samineni — Fri, 17 Mar 2017 09:49:27 GMT

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

Re: Set analysis problem

Fri, 17 Mar 2017 09:53:24 GMT

Try this ,working fine for me .

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

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

Re: Set analysis problem

sravanthialuval — Fri, 17 Mar 2017 09:57:07 GMT

Try this

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

Re: Set analysis problem

Fri, 17 Mar 2017 09:57:53 GMT

That didn't help

Thx anyway

Re: Set analysis problem

Fri, 17 Mar 2017 10:01:44 GMT

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

Re: Set analysis problem

Fri, 17 Mar 2017 10:05:52 GMT

Returns zero values and results must be in two separate columns

Re: Set analysis problem

Anil_Babu_Samineni — Fri, 17 Mar 2017 10:23:36 GMT

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

Re: Set analysis problem

Fri, 17 Mar 2017 10:31:34 GMT

I have table with posting dates and quantity. If I wish get stock on the certain date I must sum all quantity transactions from first date. My result table must show stock on two different selected dates .

Re: Set analysis problem

Kushal_Chawda — Fri, 17 Mar 2017 10:34:20 GMT

try to exclude other period filters

Sum({1<Date={"<=$(vFirstDate)"}, Year, Month, Quarter>}Quantity)

Sum({1<Date={"<=$(vSecondDate)"},Year, Month, Quarter>}Quantity)

Re: Set analysis problem

Fri, 17 Mar 2017 10:59:07 GMT

Actually I don't have any other period filter..

Re: Set analysis problem

sunny_talwar — Fri, 17 Mar 2017 11:03:33 GMT

How about this?

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

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

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

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

Re: Set analysis problem

Kushal_Chawda — Fri, 17 Mar 2017 11:26:34 GMT

I think you already have identifier as 1, I didn't noticed. But how you are getting the values in both the variables?

Re: Set analysis problem

Fri, 17 Mar 2017 12:03:57 GMT

From Slide/Calendar object

Re: Set analysis problem

Fri, 17 Mar 2017 13:19:58 GMT

Thx a lot, first solution works for me

I owe you a beer

Re: Set analysis problem

sunny_talwar — Fri, 17 Mar 2017 13:21:21 GMT

What's the address?