Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor III

Script Help???

Hi Folks ,

Below is my expression :

Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0))

*1000000

I'm calling a bar chart with Month as Dimension , but I'm getting "no data displayed value" when I'm calling above expression.

Not sure If my expression is correct or not?

Kindly suggest!

Thanks

AS

13 Replies
Digvijay_Singh
Honored Contributor III

Re: Script Help???

Are you multiplying 1000000 with the whole or denominator only? Please verify.

Re: Script Help???

try this

=Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/

(alt(pick(match(Complaint_Type,'3','1','2','7'),

Sum (QTY_Delivered_TOTAL),Sum (QTY_Delivered_TOTAL), Sum (QTY_Received_TOTAL), Sum (QTY_Received_TOTAL)),0)

*1000000)

amit_saini
Honored Contributor III

Re: Script Help???

with Whole

amit_saini
Honored Contributor III

Re: Script Help???

Sorry Kush same issue!

Thanks,
AS

sasiparupudi1
Honored Contributor III

Re: Script Help???

I would separately put the expressions in a text object and see whats going on

Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)

if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0))

hth

Sasi

amit_saini
Honored Contributor III

Re: Script Help???

Sasidhar,

I have already tried this , upper part alone is working fine but below part always showing me zero.

Thanks,

AS

Digvijay_Singh
Honored Contributor III

Re: Script Help???

But currently it is multiplying with denominator only, try this to multiply to whole -

=Sum(({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/

  if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0)))*1000000

agni_gold
Valued Contributor II

Re: Script Help???

Can you please attach your sample application.

Digvijay_Singh
Honored Contributor III

Re: Script Help???

Made mistake, you may need bracket before Sum..

Community Browser