topic Re: Cycle Group not available in Edit Expression in QlikView

Cycle Group not available in Edit Expression

Wed, 14 Oct 2015 10:25:50 GMT

Hi,

Qlikview newbie here. I've created a cycle group of Year, Month, and Day that an item was entered called DateCycleGroup. I've then created a stacked bar chart with this cycle group and the type of item as dimensions. I then want to have the bars all add up to 100% and for the % of each type's quantity sold to to be divided amongst this 100%. So I want to have an expression something like Sum(item_quantity_sold)/Sum(TOTAL <DateCycleGroup> item_quantity_sold).

My problem is my cycle group does not seem to be accessible in the Edit Expression window so I've got a red line under DateCycleGroup when I enter the above expression. Cycle groups should be available to be used in expressions shouldn't they? None of the cycle groups I have set up appear to be accessible from the Edit Expression window. I suspect I'm missing something quite obvious!

Re: Cycle Group not available in Edit Expression

crystles — Wed, 14 Oct 2015 17:51:44 GMT

I do believe that cycle groups only work for the dimensions.

There is a way to get the % for the types of quantity sold. and have it add to 100%.

If you have the dates as the dimension (cycle group), then you can put the formula you have as the expression and filter for each type in different expressions.

Dim:DateCycleGroup

Exp 1: Sum({<Type=Item1>} item_quantity_sold)/Sum(TOTAL item_quantity_sold)

Exp 2: Sum({<Type=Item2>} item_quantity_sold)/Sum(TOTAL item_quantity_sold)

Re: Cycle Group not available in Edit Expression

Thu, 03 Dec 2015 12:38:24 GMT

Hi Crystles,

I am new to Qlikview; I found your post very helpful; as it relates to NOT being able to reference Cycle Group in Expressions. Do you have an example of how this would work; once the two expressions is added; such as (.qvw) or snapshot of the conditions? I did what you suggested and created two expressions for each dimension type within the Dim Cycle Group. Is there additional step, such as configuring the conditions to know which expression to show based on the active dimension selected within the DimCycleGroup?

Thanks,

James

Re: Cycle Group not available in Edit Expression

mayankraoka — Thu, 03 Dec 2015 12:50:39 GMT

Hi ,

You can use something like this:

	=Pick(
	Match(
	GetCurrentField([cycllicGroupName]),
	'dim1'
	,'dim2'
	,'dim3'
	),

sum(SALES/1000)

,sum(SALES/1000)

	,sum(SALES/1000)
	)

Regards,

Mayank