Cyclic in pivot table ?

[suvechha_b]

how to use cyclic in pivot table of qlikview ?

Can any one suggest me .

[#2]

You could cycle over your time?

Eg. make a cycle group called CycleTime

Include, Year,Quarter,Month example.

Then you can cycle between these. Example, you could in your dimension add - ProductNames and CycleTime. Then you would cycle between year,month,quarter on these products.

[suvechha_b]

But I have put the group in expression of pivot table.

The image is not displayed

[#4]

Hi,

If you want to use cyclic group then Go to chart

Properties->Dimensions->Edit Grops(button)->New->Select radio button for cyclic group->Give name to the group

->Add the fields you want to have in the cyclic group.

Now you have the newly added cyclic group name in the available fileds/Groups

Add your new group as the one of the dimension in the chart

Hope it helps you

Thanks and Regards,

S.Amuthabharathi

[suvechha_b]

But I have put the group in expression of pivot table not in dimension.

[Carlos_Reyes]

So, you put together two expressions and that became a cyclic expression?

I don't think you can interact with a cyclic expression if you have a crossed dimension in you pivot table. Although, perhaps you may use the conditional field for each expression and create and external field that can trigger which one will be shown.

[kedar_dandekar]

Hi,

Is your pivot table similar to the one attached?

KD

[#8]

You cannot cycle through expression like you make on dimensions, but you can group your expressions under expressions and hereby you can make a cycle of which expressions you want.

Otherwise you should load the expressions into a table, but that would be kinda ugly i think.

[er_mohit]

For expreesion side if you have more than one expression then select 2nd expression and you ll see that below group button is active then you can easily group both expression

hope it helps