topic Re: calculated dimension in QlikView

calculated dimension

prma7799 — Fri, 20 Nov 2015 05:35:04 GMT

Hi All,

How to write below expression in dimension.

[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}

Thanks

Re: calculated dimension

tamilarasu — Fri, 20 Nov 2015 05:40:16 GMT

Try,

If([First Invioce Date]>=Date(vStartDate) and [First Invioce Date]<=Date(vEndDate),

[First Invioce Date]

)

Re: calculated dimension

prma7799 — Fri, 20 Nov 2015 05:48:36 GMT

Hi Tamil ,

Your suggestion is right but am taking [First Invioce Date] ,Product and many more dimension for [First Invioce Date] is showing perfect range but for product it will not display for that range .

kindly help.

Re: calculated dimension

tamilarasu — Fri, 20 Nov 2015 05:53:49 GMT

I am not understand your requirment clearly.

You mean this,

If([First Invioce Date]>=Date(vStartDate) and [First Invioce Date]<=Date(vEndDate),

Product

)

If not, could you elaborate or post sample application.

Re: calculated dimension

Fri, 20 Nov 2015 05:57:56 GMT

Hi,

Try this,

{<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}

KR,

Hasvine

Re: calculated dimension

PrashantSangle — Fri, 20 Nov 2015 05:59:27 GMT

Hi,

If possible move your condition either in script or in Expression.

if you want in expression you can try liike

Only({<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>} Product)

Regards

Re: calculated dimension

Fri, 20 Nov 2015 05:59:30 GMT

Example:

Sum({<[First Invioce Date]={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}XXXXX)