topic Cyclic in pivot table ? in QlikView

Cyclic in pivot table ?

suvechha_b — Tue, 10 Sep 2013 13:57:31 GMT

how to use cyclic in pivot table of qlikview ?

Can any one suggest me .

Re: Cyclic in pivot table ?

Tue, 10 Sep 2013 13:59:57 GMT

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.

Re: Cyclic in pivot table ?

suvechha_b — Tue, 10 Sep 2013 14:17:20 GMT

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

The image is not displayed

Re: Cyclic in pivot table ?

Tue, 10 Sep 2013 14:20:04 GMT

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

Re: Cyclic in pivot table ?

suvechha_b — Tue, 10 Sep 2013 14:22:07 GMT

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

Re: Cyclic in pivot table ?

Carlos_Reyes — Tue, 10 Sep 2013 16:57:23 GMT

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.

Re: Re: Cyclic in pivot table ?

kedar_dandekar — Tue, 10 Sep 2013 19:16:54 GMT

Hi,

Is your pivot table similar to the one attached?

Re: Re: Cyclic in pivot table ?

Wed, 11 Sep 2013 06:14:28 GMT

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.

Re: Cyclic in pivot table ?

er_mohit — Wed, 11 Sep 2013 06:49:01 GMT

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