topic Re: one dimension two expression in bar chart in QlikView

one dimension two expression in bar chart

Anonymous — Wed, 27 May 2015 05:48:15 GMT

Hi,

In this Dashboard if i select 'MADE SLA' bar should have populate 'MADE SLA' data in the below Ticket Details table but bars are not selecting can anybody please help me out ..

Thanks,

Dev

Re: one dimension two expression in bar chart

john_s_w_wood — Wed, 27 May 2015 07:56:59 GMT

Hello Dev

Can you make some selections then select file, reduce data, keep possible data (backup first). Its a big file 66mb and my connection is not very good at the moment so its taking a long time to download

Thanks John

Re: one dimension two expression in bar chart

Anonymous — Wed, 27 May 2015 10:04:32 GMT

Re: one dimension two expression in bar chart

buzzy996 — Wed, 27 May 2015 10:11:48 GMT

as per my understanding,those two (MADE SLA ,MISSED SLA) are not fields in ur schema,so it wont change by slecting any one of those 2,as u know qlikview is associative model..that's way..and so ur data should link with based on fields,but it's not happing here in this case

Re: one dimension two expression in bar chart

Anonymous — Wed, 27 May 2015 11:44:49 GMT

Is there any solution for this ??

I want to see Made sla tickets and missed sla tickets sperately ..that's what client expecting..

Re: one dimension two expression in bar chart

buzzy996 — Wed, 27 May 2015 11:49:00 GMT

if u have no problem,then u can try with script like if(ur-sla-condition-meet,'MADE SLA','MISSED SLA') as SLA

then use SLA field in ur chart objects and see?