topic Re: Stuck with this Chart in QlikView

Stuck with this Chart

Fri, 25 Sep 2015 13:40:44 GMT

Hi Community,

I have to create the below chart in Qlikview with the dimensions which are not actually part of any table ( %SDC & % FTR).

But the logic to arrive is given in the below screen shot. and chart should to dynamically change when we select any Date or any other filters used in the Dashboard. kindly suggest how to achieve this.

Re: Stuck with this Chart

malini_qlikview — Fri, 25 Sep 2015 15:12:06 GMT

You Create an inline table with a column having %SDC,%FTR and %of BM and use it in the dimension of the chart.

In the expression use conditional function to use the SDC/FTR formulas respectively

Re: Stuck with this Chart

Sat, 26 Sep 2015 13:03:29 GMT

Hi Malini, thanks for the reply.

I have used the below condition, but only %SDC bar is appearing.

If(List='% of SDC',Median({<No_Days = {'00'}>} Ticketno),

If(List='% of FTR',Median({<[Openedby] = {[Closedby]}>} Ticketno)))

Not sure where it went wrong !

Openedby and Closedby are the column names.

Re: Stuck with this Chart

Anonymous — Sun, 27 Sep 2015 17:27:23 GMT

Hi,

you can create a calculated dimension as: Valuelist('% SDC', '% FTR')

then in expression:

if( Valuelist('% SDC', '% FTR')='% SDC', expression for % SDC, expression for % FTR)

KR,

Elena