topic Re: How do I create a Calculated Dimension to do Stratification in a Straight Table in QlikView

How do I create a Calculated Dimension to do Stratification in a Straight Table

cliff_clayman — Wed, 28 Mar 2018 21:05:16 GMT

I am trying to make a stratification chart to show different "buckets" for expenditures. I would like to have buckets of 0-500, 500-1000, 1000-2000, 2000-5000, 5000+. The field that I am doing this on is called Expense Amount. I would like a calculated dimension for this. How can this be done?

Re: How do I create a Calculated Dimension to do Stratification in a Straight Table

MK_QSL — Wed, 28 Mar 2018 21:07:44 GMT

This is similar to this..

class function Label

Creating buckets

Buckets

Re: How do I create a Calculated Dimension to do Stratification in a Straight Table

Anonymous — Wed, 28 Mar 2018 23:24:07 GMT

class in the script and chart or Intervalmatch in the script

LOAD *, class(Age, 10, 'age') As Agegroup; LOAD * INLINE [ Age, Name 25, John 42, Karen 53, Yoshi];

Inner Join IntervalMatch (Date,Key) LOAD FirstDate, LastDate, Key resident Key;