topic Re: How to create Combo Chart with Time Dimensions? in QlikView

How to create Combo Chart with Time Dimensions?

Fri, 18 Mar 2016 08:29:32 GMT

Hi Folks,

This report create in Qliksense....

Please find below attached sample data.

I need to create a Combo Chart in Time Dimensions..

Requirements:-

1. display latest 12 weeks data (default)

2. when i select quarter/s - display 3 months data

3. when i select month/s - display weekly data

Sub2u444

Re: How to create Combo Chart with Time Dimensions?

jonathandienst — Fri, 18 Mar 2016 09:02:56 GMT

Rather than trying to create a very complex sheet object to all that you need, create 3 charts that will be in the same position in the sheet and use the following conditional display expressions (in the Layout tab)

default - GetSelectedCount(Quarter) = 0 And GetSelectedCount(Month) = 0

3 months - GetSelectedCount(Quarter) > 0 And GetSelectedCount(Month) = 0

weekly - GetSelectedCount(Month) > 0

(adjust for you field names and for the 'priority' of the month and quarter selections)

Re: How to create Combo Chart with Time Dimensions?

Fri, 18 Mar 2016 09:30:17 GMT

Thanks for reply.

These three show in combo chart..

Sub2u444‌