topic Create Two periods Selections in QlikView

Create Two periods Selections

Sun, 17 Jan 2016 09:57:03 GMT

Hey guys,

How can i create the underneath selections see the red (see red markered zone) in to qlikview ? which variables and expressions should i create?

Note: this Report is from SQL Server Reporting Services.

Greets,

Rega

marcus_sommer — Sun, 17 Jan 2016 14:59:19 GMT

- Marcus

t_chetirbok — Mon, 18 Jan 2016 15:17:58 GMT

Hello!

You can use Slider/Calendar Object (in your example it's need 4 objects).

Add variables for each Calendar Object (vPeriod1Start,vPeriod1End, vPeriod2Start,vPeriod2End).

and your expression look like:

1) count({< DATE= {">='$(vPeriod1Start)'<='$(vPeriod1End)'"}>} VALUE)

2) count({< DATE= {">='$(vPeriod2Start)'<='$(vPeriod2End)'"}>} VALUE)

And for your label column use expression: date($(vPeriod1Start))&' to '&date($(vPeriod1End))