topic Re: Comaprison of Two Dates in QlikView

Comaprison of Two Dates

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a chart showing Value vs Category.

In selection I have a date selection called Delivery Req. Date. And current logic is Qlik will calculate the Max Date and Max Date -30, on the basis of selected Date and show the values on that period.

Existing:

Now user wants to select two Delivery Req. Date and chart will show two bar chart against two date.

Can u please help me to implement that.

Required:

Re: Comaprison of Two Dates

tresB — Tue, 08 May 2018 10:55:23 GMT

Hi Sarif, hope you are doing good.

The easiest way would be to include the date field in the dimension of the chart and exclude it's restriction from set analysis section of expression. PFA

Re: Comaprison of Two Dates

mhmmd_srf — Tue, 08 May 2018 11:02:45 GMT

HeyTresesco,

I am doing good. How about u?

Tresesco two things here:

1. User need to different Selection Box for Date.

2. There is a calculation like :

CstDate1 = {'>=$(=$(vMaxDate_30)) <$(=$(vMaxDate))'}

The selected date would participate in this Set Analysis.

Please let me know if you need any other info.

Thanks,

Sarif

Re: Comaprison of Two Dates

Anil_Babu_Samineni — Tue, 08 May 2018 11:12:28 GMT

Does this helps?

=Sum({<CstFiscalPeriod,CstFiscalYear,DateSnapshot_Key = {'$(=$(vDateSnapshot))'}, CstDate1 *= {">=$(=$(vMaxDate_30)) <=$(=$(vMaxDate))"}>} LineValue)

Re: Comaprison of Two Dates

mhmmd_srf — Tue, 08 May 2018 11:18:52 GMT

Can you please out this into the attached app and share.

This would be very helpful for me to understand in short time.

Thanks,

Sarif

Re: Comaprison of Two Dates

tresB — Tue, 08 May 2018 11:22:40 GMT

You mean that there should be check that selected two dates should be within the given range?

Re: Comaprison of Two Dates

mhmmd_srf — Tue, 08 May 2018 11:45:40 GMT

For two different Date Selection the similar logic would be applied.

Chart would display the value between selected date and (selected date - 30) range.

Sum({Date > Selected Date1 - 30 and Date< Selected Date1} Values)

Sum({Date > Selected Date2 - 30 and Date< Selected Date2} Values)

Please let me know if u need any further details.

Thanks,

Sarif

Re: Comaprison of Two Dates

tresB — Tue, 08 May 2018 13:20:26 GMT

Something like this?