topic Re: switching timeframe chart in dimension in QlikView

switching timeframe chart in dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I trying to do a monthly and weekly trend chart switch.

But it doesnt let me toggle the change between monthly or weekly.

And how can i change the font size of the value in the chart?

I cant find it anywhere to change it.

Thanks

Re: switching timeframe chart in dimension

fvelascog72 — Mon, 31 Oct 2016 12:01:04 GMT

Hi,

Can you explain more your first question?

To the second question you can use:

If(Month=6,'<B>'&'<I>'&'<U>'&'<H1>')

in Text Format in graphics attributes of the expression.

Re: switching timeframe chart in dimension

Frank_Hartmann — Mon, 31 Oct 2016 12:10:38 GMT

see attached file.

try creating a cyclic group. then you are able to switch.

hope this helps

Re: switching timeframe chart in dimension

Mon, 31 Oct 2016 12:20:24 GMT

Hi Federico,

I got the solution already, thanks anyway for the font size.

Re: switching timeframe chart in dimension

Frank_Hartmann — Mon, 31 Oct 2016 12:23:39 GMT

for your second probleme try as following:

Re: switching timeframe chart in dimension

Mon, 31 Oct 2016 12:24:59 GMT

Hi Kok,

Below picture illustrates how drill down works, if thats not how you intended, use cyclic group provided by 'Frank Hartmann'.

Re: switching timeframe chart in dimension

Fri, 04 Nov 2016 11:40:22 GMT

Hi Frank,

I have managed to do the switch time frame on the chart by cyclic group.

How can i create a separate Button instead to toggle the time frame(month,week,day) instead on the chart itself.

Thanks

Re: switching timeframe chart in dimension

Frank_Hartmann — Fri, 04 Nov 2016 11:54:56 GMT

have a look at attached sample!

hope this is helpful!

---- Edited ----

Re: switching timeframe chart in dimension

Fri, 04 Nov 2016 12:17:38 GMT

Hi Frank

Doesnt work on my version, not sure what is missing.

Showing '1' and '4'

Re: switching timeframe chart in dimension

Frank_Hartmann — Fri, 04 Nov 2016 12:29:12 GMT

in the listbox you will have to put this formula to the expression, not to the title:

=if($Field='Week',$Field,if($Field='Month',$Field,if($Field='Day',$Field)))

In the charts only use this expression as dimension:

=$(= '[' & ONLY($Field) & ']')

Thats it. See attached sample

hope this helps!