cyclic group within same field??

Wed, 22 Jun 2011 19:40:20 GMT

Hello,

I have a table that has two fields. Periods and consumptions. Periods has two kind of periods. one period and four periods...and these two types have different consumption. now I want a chart that has cyclic group within this periods field (User being able to select whether one period or four period.). I know that when you have two fields, you just create new group and drop those two fields there. but is there any way to make a cyclic group within the same field values

Arif

cyclic group within same field??

Wed, 22 Jun 2011 20:36:59 GMT

You can add calculated dimensions to a cyclical group. Just click the 'Add Expression' button under the 'Used Fields' box in the Group Settings box.

dimension 1: if(period = 1, 1, null())

dimension 2: if(period = 2, 1, null())

Then in your dimension settings check the 'Suppress if value is null' box to limit it to show only those values for the appropriate period.

topic cyclic group within same field?? in QlikView

cyclic group within same field??

cyclic group within same field??