Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Bar Charts and Set expressions

All,

I think I am likely missing something simple here, but I a stumped.  I am working with some product usage data that looks basically like:

MonthAccountIDUsage
1/1/201512350
1/1/201545675
2/1/201512360
2/1/2015456100
etc

What I want to do is create a bar chart that shows the Growth in usage each month using 1/1/2015 as the baseline.  So essentially 1/1/2015 would have a value of 0 and 2/1/2015 would have a value of 35(60-50 and 100-75)

I thought I could use something like:

Dimension - Month.autocalendar.YearMonth

Measure - Sum(Usage) - Sum ({$<Month = {'1/1/2015'}>}Usage)

But this just takes the January 2015 value to 0 and does not change any of the other months.

Any suggestions?

1 Solution

Accepted Solutions

Re: Bar Charts and Set expressions

My bad, you need this:

Sum(Usage) - Sum (TOTAL <AccountID> {$<Month = {'1/1/2015'}>}Usage)

2 Replies

Re: Bar Charts and Set expressions

Try this:

Sum(Usage) - Sum (TOTAL {$<Month = {'1/1/2015'}>}Usage)

Re: Bar Charts and Set expressions

My bad, you need this:

Sum(Usage) - Sum (TOTAL <AccountID> {$<Month = {'1/1/2015'}>}Usage)