Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Target Values Implementation Help

Hi Folks,

Please see the attachment and suggest what could be the best way of showing weekly target numbers in line graph.

Thanks,

AS

6 Replies
amit_saini
Honored Contributor III

Re: Target Values Implementation Help

Any suggestions plz ???

Thanks,

AS

qvraj123
Contributor II

Re: Target Values Implementation Help

document size is too big - does not download at all

- may be what you are asking is not clear

amit_saini
Honored Contributor III

Re: Target Values Implementation Help

Rajender,

Below is my link charts :

Dimm- Weeks

Expression :

if( QDR_Dim='QDRi',

count(distinct {<Complaint_Type={2}, C_Group={'Plants'}  >} NRQNR),

    if( QDR_Dim='QDRe', count(distinct {<Complaint_Type={3} >} NRQNR),

        if( QDR_Dim='QDR', 

     count(distinct {<Complaint_Type={2}, C_Group={'Plants'}  >} NRQNR) +   count(distinct {<Complaint_Type={3} >} NRQNR),

      count(distinct {<Complaint_Type={2}, C_Group={'Plants'}  >} NRQNR) +   count(distinct {<Complaint_Type={3} >} NRQNR))

) )

-

if( QDR_Dim='QDRi',

count(distinct {<Complaint_Type={2}, Complaint_Acceptance={'4','5','6','7'},C_Group={'Plants'}  >} NRQNR) ,

    if( QDR_Dim='QDRe',  count(distinct {$<Complaint_Type={3}, Complaint_Acceptance={'4','5','6','7'} >} NRQNR),

        if( QDR_Dim='QDR', 

        count(distinct {<Complaint_Type={2}, Complaint_Acceptance={'4','5','6','7'},C_Group={'Plants'}  >} NRQNR) +  count(distinct {$<Complaint_Type={3}, Complaint_Acceptance={'4','5','6','7'} >} NRQNR),

        count(distinct {<Complaint_Type={2}, Complaint_Acceptance={'4','5','6','7'},C_Group={'Plants'}  >} NRQNR) +  count(distinct {$<Complaint_Type={3}, Complaint_Acceptance={'4','5','6','7'} >} NRQNR)

        )))

In this line chart I need to show weekly Target values . For Fuel =10 , For CVS=2 and for IP=2

Thanks,

AS

MVP
MVP

Re: Target Values Implementation Help

I will not download such a large file. I suggest that you follow the advice in this post:

Preparing examples for Upload - Reduction and Data Scrambling

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
amit_saini
Honored Contributor III

Re: Target Values Implementation Help

Thanks Jonathan for sharing this.

Attached is the new file.

Thanks,

AS

amit_saini
Honored Contributor III

Re: Target Values Implementation Help

Any suggestions ???

Community Browser