topic Re: Trellis Chart - help in QlikView

Trellis Chart - help

Thu, 11 Oct 2012 09:10:42 GMT

Dear All,

When i try to create the trellis chart with quarter and month as dimension and sum(amount) as Expression.

each quarter shows all the month, but i want to show only for Q1 it should be jan-mar, Q2 is Apr-Jun...

I dont know where its going wrong..

is there any bug in Qv11 Sr1.

thanks in advance.

fdelacal — Thu, 11 Oct 2012 09:31:56 GMT

you can create a cyclic group and add this expression.

=if(QUARTER= 'Q1',QUARTER)

=if(QUARTER= 'Q2',QUARTER)

=if(QUARTER= 'Q3',QUARTER)

=if(QUARTER= 'Q4',QUARTER)

i hope you help this solution.

Thu, 11 Oct 2012 10:38:52 GMT

thanks for ur reply,

I want the chart like rohit attachment.

your chart shows q1 for jun and jul and q2 also shows jun and jul.

actually q1 should show only jun and q2 should show only jul.

the same problem i am getting in my chart...

Thu, 11 Oct 2012 17:23:19 GMT

Hi,

I attached the sample trellis chart.

i suppose to show jan - mar in Q1, but it shows all the months in Q1..

similarly for Q2, Q3, Q4.

Could anyone help me to resolve this issue...

thanks in advance.

Fri, 12 Oct 2012 06:41:05 GMT

Hi Rohit,

Could u please tell me whats the difference between ur attachment and my attachment...

both of them same only.

see my req is i dont want to see the months which are not in the quarter.

the chart should be like Jan,Feb,Mar in Q1. i dont want to see any other months in Q1.

Bcoz it will give wrong picture to the end user.

Fri, 12 Oct 2012 07:38:04 GMT

Hi,

Maybe you could check this one.

Regards,

Janzen