topic Re: Apply Cycle on a column in QlikView

Apply Cycle on a column

Thu, 23 Jan 2014 23:24:18 GMT

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

Re: Apply Cycle on a column

phaneendra_kunc — Thu, 23 Jan 2014 23:35:03 GMT

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...

Re: Apply Cycle on a column

Fri, 24 Jan 2014 00:25:44 GMT

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

Re: Apply Cycle on a column

phaneendra_kunc — Fri, 24 Jan 2014 00:38:12 GMT

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.

Re: Apply Cycle on a column

jagan — Fri, 24 Jan 2014 03:02:35 GMT

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.

Re: Apply Cycle on a column

Fri, 24 Jan 2014 17:37:58 GMT

I thought of implementing the if condition, but the data varies everytime..so even I did not want to implement it

The 2nd option is closer to my requirement

Thanks a lot!

Re: Apply Cycle on a column

Fri, 24 Jan 2014 17:38:41 GMT

Thanks Phaneendra I was just checing out the options

thanks alot!