topic Re: 2 Calendar object in one selection in QlikView

2 Calendar object in one selection

ilanbaruch — Wed, 05 Jul 2017 16:29:41 GMT

hi all,

in my model i use calendar object to select date range dynamically,

i want to enhance that and compare values between different dates

Date_A and Date_B are originally Date field loaded with alias to use two Calendar object.

all is working well separately but when selecting both, first selection drops off the current selection..

i use below expressions in the table but only one can work at the time..

any ideas?

sum({$<Date_A =>}Amount)

sum({$<Date_B =>}Amount)

Anil_Babu_Samineni — Wed, 05 Jul 2017 16:48:11 GMT

I would ask you to write something like below

Sum({<Date_A = {">=$(Period_A_From) <=$(Period_A_To)"}, Date_B = {">=$(Period_B_From) <= $(Period_B_To)"}>} Amount)

ilanbaruch — Thu, 06 Jul 2017 06:50:04 GMT

hi Anil, thanks for your swift replay.

solved it with below expressions

period a

Sum({$<date_a={"<=$(vEndDate)>=$(vStartDate)"}>}amount)

period b

Sum({$<date_b={"<=$(vRangeEnd)>=$(vRangeStart)"}>}amount)

again thank you

Anil_Babu_Samineni — Thu, 06 Jul 2017 07:02:03 GMT

This make sense and i would ask you to write like below for next KT person

period a

Sum({$<date_a={">=$(vStartDate)<=$(vEndDate)"}>}amount)

period b

Sum({$<date_b={">=$(vRangeStart)<=$(vRangeEnd)"}>}amount)