netk week delivery only in Expression

[Anonymous]

Count({<[Delivery Week]={Week(Today)>} [Customer Name])... it throws error...pls coorrect it

[tresesco]

Probably you are missing one'}', try it as : Count({<[Delivery Week]={Week(Today)}>} [Customer Name])

Regards,  tresesco

[CELAMBARASAN]

Hi,

     Try with this expression

     Count({<[Delivery Week]={$(=Week(Today))}>} [Customer Name])

Celambarasan

[Anonymous]

your expression also error... i think week(today()) is inbetwwen the quotes ..but it showing error

[Anonymous]

no i want general where condition not current selection

[CELAMBARASAN]

Hi,

     You mean independent of other field selection?like this?

     Count({1<[Delivery Week]={$(=Week(Today()))}>} DISTINCT [Customer Name])

Celambarasan

[tresesco]

So you mean tried this also,

Count({<[Delivery Week]={"=Week(Today())"}>} [Customer Name])

Regards,  tresesco

[jagan]

Hi,

Try using the below expressions

Count({<[Delivery Week]={$(=Week(Today()))}>} [Customer Name])

OR

Count({<[Delivery Week]={'=$(=Week(Today()))'}>} [Customer Name])

OR

Count({<DateField={'>=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))'}>} [Customer Name])

Regards,

Jagan.

[Anonymous]

how to use without current selection($)

[CELAMBARASAN]

Hi,

     Here $(=) its not a current selection its to telling the qlikview to evaluate the expression inside it.It means dollar expansion.

     Count({$<fields>} FieldName) (This will be used for current selection)

     Count({1<fields>} FieldName) (This will be used to ignore the current selections)

Hope it helps

Celambarasan