Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Status changes

I have a handful of records:

IDStatusStatusDateCount
1Open1/1/131
1Closed1/15/131
2Open1/10/131
2Closed1/30/131

I want to make a barchart that will show every day of the year on the X axis (using a master calendar tied to StatusDate), with a sum of Open records on the Y axis (EVERY DAY).

The above data should show:

1 from 1/1/13 through 1/9/13

2 from 1/10/13 through 1/14/13

1 from 1/15/13 through 1/29/13

Is it possible to do this with just the data above, or do I need to make a new record for every single day of the year, per ID (lots and lots more data)?

Thank you

1 Solution

Accepted Solutions

Re: Status changes

See here


talk is cheap, supply exceeds demand
1 Reply

Re: Status changes

See here


talk is cheap, supply exceeds demand
Community Browser