topic Dynamic title when cyclic group is selected in QlikView

Dynamic title when cyclic group is selected

Wed, 18 Nov 2009 09:01:10 GMT

Hello,

i have few question regarding cyclic group.

1. The cyclic group always shows static title like the following. says if i have 2 selections - "Month", "Year", how can i make the title in this case - "Type" change accordingly to "Year" / "Month" ?

2. How can i position it from left top to right-bottom?

3. how can i create a dynamic title for my chart? i needed something like "Total Sales by <Month / Year>"

Thanks,
Nick

Dynamic title when cyclic group is selected

Wed, 18 Nov 2009 10:02:07 GMT

ok, i did Qns 3 like..

if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

and now i have another problem... i'm able to include additional strings at the end of the formula using & ' abc ' , but how can i do the same for the front?

it doesn't work if i do this 'Total by'& =if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

Dynamic title when cyclic group is selected

Wed, 18 Nov 2009 10:27:36 GMT

ok, here is the answer for Qns 1, just have to uncheck the LABEL box in DIMENTION tab. :]

Dynamic title when cyclic group is selected

Wed, 18 Nov 2009 17:35:22 GMT

To change the position of you cyclic button push CTRL + SHIFT Button, then you'll see red squares in your chart, allowing to move some items.

Dynamic title when cyclic group is selected

sparur — Wed, 18 Nov 2009 17:53:36 GMT

Hi,

try that:

'Total by'& if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

Qns 2: it's impossible, as I Know

Dynamic title when cyclic group is selected

Thu, 19 Nov 2009 10:06:43 GMT

Hi,

Yeah, it's not possible. i can see the red square, but it wont move the cyclic to anywhere.

for the formula, i did try that too, but it's not working either.

the problem is, you can't have anyhting, not even a space, in front of the "=" sign, otherwise the whole formula wont work. it's weird....

Dynamic title when cyclic group is selected

Thu, 19 Nov 2009 16:11:54 GMT

Hi Nick

On Question 2, I agree with Spastor that you should use CTRL-SHIFT, keep those buttons held down, use the mouse to drag & drop the cyclic group title where you want. I use this all the time, I just used it on another object and it worked with no problem at all.

Not sure which formula you are referring to when you say its not working, but if it's the title formula suggested above, just try putting an = sign at the left side of that formula.

Dynamic title when cyclic group is selected

Thu, 26 Nov 2009 18:29:51 GMT

Still.... the CTRL+SHIFT doesnt work. i can move the title and legend to wherever i want, but not the cyclic, i don't know why.

for the formula if i do this > "=if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'" it works and will return > Market (Target = 28)

but i wanted to do this > Chart by Market (Target = 28)
If i put a space infront of the equal sign, it wont work > " =if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'" it wont work, meaning, i can't even put anything in before the equal sign, i tried many ways.. like " 'Chart by'&=if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'"

As long as i put anything infront of the equal sign, it returns the formula as string to me as a whole.

Any other solutions ?

Dynamic title when cyclic group is selected

Thu, 26 Nov 2009 18:42:04 GMT

I have no idea why the CTRL-SHIFT does not work!!

For the formula.....

= 'Chart by ' & IF(GetCurrentField(TotalLeadTime)='CreaMonth','Month','Market') & ' (Target = 28 days)'

Dynamic title when cyclic group is selected

Thu, 26 Nov 2009 19:24:02 GMT

AH HA ! why didn't I think of that.... lol.. it works perfect now ! Thanks.

As for the cyclic, i think it must be that particular chart, cos the other works fine.

Thanks for the help.