Solved: Apply Cycle on a column - Qlik Community

Report Inappropriate Content · ‎2014-01-23

Hi all,

I want to apply cycle function on Title column in table. Please find the sample data below

Title	County	value
Lifetime Likes by Age	N/A	112
Lifetime Likes by City	atlanta	114
Lifetime Likes by City	bangalore	287
Lifetime Likes by City	chicago	98
Lifetime Likes by City	dallas	145
Lifetime Likes by Gender	doylestown	227
Lifetime Likes by Gender	herndon	70
Lifetime Likes by Gender	hyderabad	106
Lifetime Likes by Gender	jakarta	157
Lifetime Likes by Gender	livingston	109
Lifetime Likes by Gender	los angeles	186
Lifetime Likes by Gender and Age	mexico city	71
Lifetime Likes by Gender and Age	mumbai	225
Lifetime Likes by Age	CA	123
Lifetime Likes by Language	EG	52
Lifetime Total Likes	ES	53
Lifetime Total Likes	FR	96
Lifetime Total Likes	GB	140
Lifetime Total Likes	ID	173
Lifetime Total Likes	IN	866
Lifetime Likes by Country	IT	78
Lifetime Likes by Country	JP	50
Lifetime Likes by Country	KR	87
Lifetime Likes by Country	MX	110
Lifetime Likes by Country	MY	69
Lifetime Likes by Country	PH	77

I display it as attached file.

Is it possible in qlikview? (the data in in TITLE is updated daily)

thanks

jagan · ‎2014-01-23

Hi,

It is not possible to give dimension values as Cycle instead you can change your datamodel in such a way that each distinct individual value as separate dimension, but in reality it is a hectic task, you have change the script and charts everytime when New title is added into the dashboard.

Example:

LOAD

Country,

Value,

If(Title = 'Lifetime Likes by Age', Title) AS [Lifetime Likes by Age],

,

FROM DataSource;

Instead of this what I would suggest is you can provide a filter in the Table Header by using

Chart Properties -> Presentation Tab -> Select Title column in Columns -> Select Dropdown Select option. I think this is the better option.

Hope this helps you.

Regards,

jagan.

View solution in original post

phaneendra_kunc · ‎2014-01-23

is there any specific reason you what your data in Title column in cycle group?

what happens if user cycles and selects "Lifetime Likes by City" , will it filter the data for this?

May be you can use Multibox, or list box...

Report Inappropriate Content · ‎2014-01-23

we are using multibox, but checking if it is possible to implement cycle and filter the data on selection?

phaneendra_kunc · ‎2014-01-23

There is no straight way to implement this. you have to tweak the datamodel aswell as the UI expressions to work. and i dont recommend as it will be combersome to maintain.

jagan · ‎2014-01-23

Hi,