Date Range syntax - Qlik Community

Report Inappropriate Content · ‎2015-04-17

Hi

From Date	To Date	Marks
01012014	17042014	20
18042014	17042015	15
16052014	17062014	23
17062014	17082014	21
17072014	17092014	22

I want to take sum of Marks. For a range of dates.

can someone please help me the syntax of date range?

TIA

PrashantSangle · ‎2015-04-17

Hi,

Try like

sum(if(FromDate>=$(min(FromDate) and ToDate<=$(max(FromDate)))Marks))

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

alexandros17 · ‎2015-04-17

Cuold ypou explain better?

Report Inappropriate Content · ‎2015-04-17

I have a table with three columns.

Date, Debit and Credit.

How do I see the debit for a particular period?

Report Inappropriate Content · ‎2015-04-17

That did not work in my case.

I have a table with three columns.

Date, Debit and Credit.

How do I see the debit for a particular period?

I hope this helps you to understand the case better

rajkumarb · ‎2015-04-17

HI Arjun

Use Master Calendar

and Use Debit & Credit in Expressions

you Can Choose form Date Range

buzzy996 · ‎2015-04-17

are u looking to see ur debit between two dates? if yes..u have to create & use 2 calendar objects one for from date and seconde for todate.

from date & todate objects u can create through ur date field.