Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

parpatra
New Contributor III

Set analysis with Dates

Hi,

I have a requirement whhere I need to check how many IDs have their DATE_A in the same range as my  reporting Date.

I am trying a expression in a bar chart where:

Dimension=MONTH

Expression= =COUNT( {<DATE_A={"<=$(MAN_DATE)"},DATE_A={">=$(MIN_DATE)"},YEAR={"2011"}>} ID)

But this expression is not grouping things by Month, as it would be in a bar chart. My MIN DATE AND MAX DATE are calculated columns in t my calender  table.

MIN_DATE= ADDMONTHs(REPORTDATE,-3)

MAX_DATE=REPORTDATE

Any help is appreciated.

Thanks

1 Reply
Not applicable

Set analysis with Dates

Hello parpatra,

two things to mention:

your var MIN_DATE includes an expression (Addmonth ...). Due to this you have to use (in addition to $()) the $(=) - operator within your chartexpression. This would then look like:

COUNT( {< DATE_A={"<=$(REPORTDATE)"},DATE_A={ ">=$(=$(MIN_DATE))"},YEAR={"2011"}>} Val)

Second Note:

My var MIN_DATE looks like:

ADDMONTHs( $(REPORTDATE),-3)

and

REPORTDATE includes a valid (german) date:

'28.10.2011'

HtH

Roland