topic Re: Code Help?? in QlikView

Code Help??

rohitians — Fri, 24 Jan 2014 07:22:27 GMT

Hello,

I want count of number of brands in a period,

following is code help..

count(distinct(brand))

following code decides which brands

{< SKU_Launch_Date ={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}

not able to get it right...

Thanks and Regards,

Rohit

tresB — Fri, 24 Jan 2014 07:24:32 GMT

Try placing $ around variables.

Fri, 24 Jan 2014 07:27:44 GMT

Can you use this to get the variable value:

$(=vStartDate) and $(=vEndDate)

Gysbert_Wassenaar — Fri, 24 Jan 2014 07:31:49 GMT

Try:

{< SKU_Launch_Date ={'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}>}

It's possible you have to specify a date format too in the Date function. See this blog post: Why don’t my dates work?

rohitians — Fri, 24 Jan 2014 07:40:36 GMT

Thank you for your precious time,

count({< SKU_Launch_Date ={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}DISTINCT(BRAND))

I did this way and got the deired result..

Thanks .

Rohit