Custom date range selection in qliksense

[Anonymous]

Hi Experts,

Currently I have requirement of analyzing my data for entered data range like following.

Given date range is ( for ex) <=1/31/2017>=1/1/2017

How I can use above range in set analysis for getting sum of my field for this range?

Thanks,

Pooja

[MohammedMustaq]

Hello Pooja,

One way i found ignore selections on fields

Try this...

=Sum({<Date={"$(= '>=' & '1/1/2017' & '<='&'1/31/2017')"},Field1=,Field2=,Filed3=>}Values)

Thanks

Mohammed Mustaq

[OmarBenSalem]

u'd have a date field; the user select 2 dates from the same field; and u want to return the sales btwn the 2 selected dates?

so If ur user select, 15/11/2017 and 11/01/2018 , u want sales btwn those 2 dates right?

if u select these 2 dates:

to retrieve the min date btwn the both? =>15/11/2017 => min(Date)

to retrieve the max date btwn the both? =>11/01/2018 => max(Date)

=> sum({<Year=,Month=,Date={">=$(=min(Date)) <=$(=max(Date))"}>}Sales)

[MohammedMustaq]

Hello Pooja,

try these to ignore all field Selections.

=Sum({1<Date={"$(= '>=' & '1/1/2017' & '<='&'1/31/2017')"}>}Values)

Thanks

Mohammed Mustaq

[faridguliyev97]

Sum({<Date={"$(= '>=' & '1/1/2017' & '<=' & '1/31/2017')"}>}Values)

Here use 1 instead of dollar sign. Then it will not effect