topic Re: Cyclic group in straight table in QlikView

Cyclic group in straight table

Sat, 16 Nov 2013 11:38:53 GMT

Hi,

I have a Table Product_Category1 having Product name and Count as fields.there is another table asProduct_Category2 with Product name and Count..

I want these two tables to display in Cyclic groups.Though i can place both the tables in Container object.I want a cyclic group, so once i switch from table1 to Table2,i want to my Table2 name as well as the dimensions used in it.

Re: Cyclic group in straight table

israrkhan — Sat, 16 Nov 2013 12:59:10 GMT

Hi,

why you dont concatenate both tables, and add a flage as Category1 with first table and category2 with second table, and the you can create cyclic by adding these two field, Category1, Category2, and it will work as expected.

or you can use a more easy name, instead of category1. like ProductCategory1 and so...

If you have Same name in both tables like Product Name, Then You Cant use cyclic group, how you will differentiate both products?

Khan

Re: Cyclic group in straight table

Sat, 16 Nov 2013 13:32:04 GMT

Hi Khan,

Though the field names are same in both the tables,but the field values ProductName and Count are different and we want to show it in different tables..Is there a way to use Cyclic Group on it..

Re: Cyclic group in straight table

israrkhan — Sat, 16 Nov 2013 13:45:57 GMT

Cyclic Groups are used for, to show multiple expression or dimensions in same object, (straight table, chart).

you said we want to show in different tables, then why you need cyclic group???

Re: Cyclic group in straight table

Sun, 17 Nov 2013 08:33:53 GMT

I might didn't gave a clear picture. Ofcourse i want to show the dimensions in cyclic group in Straight table format.is it possible to have it without concatenating or joining the tables.

Thanks.