Current and Previous month count total in same chart and waterfall chart

saumyashah90 — Tue, 18 Apr 2017 12:26:05 GMT

Hi ,

I have data like,

Table1:

CGID

DATE

16234

30/04/2016

16238

31/03/2016

123445

31/03/2016

423712

30/04/2016

213213

30/04/2016

34234

31/03/2016

5453254

30/04/2016

Table2:

CGID	DATE	Type	SubType
16234	30/04/2016	NC	a
16234	31/03/2016	DC	b
123445	30/04/2016	NC`	a
213213	31/03/2016	NC	d
5453254	30/04/2016	DC	e
5453254	31/03/2016	DC	d
213213	30/04/2016	DC	e
423712	31/03/2016	NC	b
423712	30/04/2016	NC	a

No i have key of CGID&DATE between both

I want waterfall chart based on SubType

Start month will be count(CGID) for March

and all others will be count(CGID) for April.

In a chart i have DATE Type as a dimension and expression i need countof CGID for current month and previous month.

And all this should filter with ID's.

and Current month (April) is selected.

topic Current and Previous month count total in same chart and waterfall chart in QlikView