topic Re: Problem with formula and time variables in QlikView

Problem with formula and time variables

Mon, 22 Apr 2013 10:44:18 GMT

Hello erverybody,

i have a problem with the following formula:

((Abladestelle=Feld 1 and BIN_ITEM_DETAIL.ACTIVATION_DATE < v24H),

count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*BMW"} >}ITEM_MASTER.ITEM_NUMBER),

if((Abladestelle=Feld 2 and BIN_ITEM_DETAIL.ACTIVATION_DATE < v24H),

count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*HOLD","*NAEL"}>}ITEM_MASTER.ITEM_NUMBER)))

It is a dimension with 2 fields and different criteria,to be issued for each a value of more than 24 hours is.

This I have tried to show a variable v24H

Once I second the If-Funktion(if((Abladestelle=Feld 2 and BIN_ITEM_DETAIL.ACTIVATION_DATE < v24H),) activate I get a null value in my pivot table.

If I disable the second function If I just get a value for Field1.

Please Help

Greetings Sven

Re: Problem with formula and time variables

sujeetsingh — Mon, 29 Apr 2013 10:52:26 GMT

Why donmt you p[ost a sample if possible,

Re: Problem with formula and time variables

Mon, 29 Apr 2013 10:54:30 GMT

use Aggr() function before count.

if((Abladestelle=Feld 1 and BIN_ITEM_DETAIL.ACTIVATION_DATE < v24H),

Aggr(count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*BMW"} >}ITEM_MASTER.ITEM_NUMBER),dimensionfield),

if((Abladestelle=Feld 2 and BIN_ITEM_DETAIL.ACTIVATION_DATE < v24H),

Aggr(count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*HOLD","*NAEL"}>}ITEM_MASTER.ITEM_NUMBER),dimensionfield)))

Re: Problem with formula and time variables

sushil353 — Mon, 29 Apr 2013 10:56:14 GMT

hi Sven,

try this:

if ((Abladestelle=Feld 1 and BIN_ITEM_DETAIL.ACTIVATION_DATE < '$(v24H)'),

count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*BMW"} >}ITEM_MASTER.ITEM_NUMBER),

if((Abladestelle=Feld 2 and BIN_ITEM_DETAIL.ACTIVATION_DATE <

'$(v24H)'),

count({<BIN_ITEM_DETAIL.BIN_CATEGORY={"SPERR2"},BIN_ITEM_DETAIL.BIN={"*HOLD","*NAEL"}>}ITEM_MASTER.ITEM_NUMBER)))

if it doesn't work then please post the sample app.

HTH

Sushil