topic Re: How to get this expression on Script?? in QlikView

How to get this expression on Script??

Thu, 26 Sep 2013 20:41:34 GMT

Hi everyone,

How can I get this expression "LOTES" on the script:

count(distinct(aggr(Nro.Lote,Nro.Mat,Nro.Lote,Período)))

So then I cant get this Expression on the script too:

if ([Lotes]<=7,([Lotes]/1)*([AhorroHsComp]), if ([Lotes]>7 ,([Lotes]/4)*(AhorroHsComp)))

Clever_Anjos — Thu, 26 Sep 2013 21:01:38 GMT

LOAD

count(distinct Nro.Lote)

from yourqvd

group by Nro.Mat,Nro.Lote,Período;

LOAD

if ([Lotes]<=7,([Lotes]/1)*([AhorroHsComp]), if ([Lotes]>7 ,([Lotes]/4)*(AhorroHsComp))) as newfield

from yourqvd;

Thu, 26 Sep 2013 21:49:24 GMT

Clever... does not work your soolution.

its returns '1'

I got this in a graph:

The column Lotes is:

count(distinct(aggr(Nro.Lote,Nro.Mat,Nro.Lote,Período)))

I need to have this values already on the script!

rbecher — Fri, 27 Sep 2013 20:04:28 GMT

Please upload sample data.

Sat, 28 Sep 2013 06:30:52 GMT

try this,

aggr(count(distinct(Nro.Lote,Nro.Mat,Nro.Lote,Período)))