topic Re: Variable for Days in QlikView

Variable for Days

Anonymous — Thu, 27 Aug 2015 12:52:40 GMT

M_date is avaiable where I need formulae M_date for a Delivered Product Vz Incorrect Product.
Here I have to use the days not the months.The days start from current date (Today)
actual month = last 30 days(variable which suits the Formulae)
month before = last 30 days to last 60 days(variable which suits the Formulae)

Re: Variable for Days

Colin-Albert — Thu, 27 Aug 2015 12:56:26 GMT

So what is your question?

Can you give a better description of what you are trying to achieve?

Re: Variable for Days

Gysbert_Wassenaar — Thu, 27 Aug 2015 12:56:52 GMT

I have no idea what you're trying to say. If you have a question you'll have to ask it a bit more clearly.

Re: Variable for Days

Anonymous — Fri, 28 Aug 2015 12:52:41 GMT

I want to form a KPI metrics(UI Design) .I have Manufaturing date / Delivered product / Incorrect product.

I have to calculate actual month = last 30 days and also actual month = last 30 days ... can any one of you can provide me the formulae or set analysis for the same

Re: Variable for Days

Anonymous — Fri, 28 Aug 2015 12:54:10 GMT

for Ex..

=((sum({<[Manufacturing year]={$(vCurrentYear)}, [Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}>}[Incorrect Quantity])/sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}>}(PosMenge))*1000000

/(sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vLastbeforemonth)}>}[Incorrect Quantity])/sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vLastbeforemonth)}>}(PosMenge))*1000000))*100)-100&'%'

I need previous 30 days instead of months ..

Re: Variable for Days

Gysbert_Wassenaar — Fri, 28 Aug 2015 12:56:59 GMT

The actual month is August: Month(Today())

Re: Variable for Days

Kushal_Chawda — Fri, 28 Aug 2015 13:09:38 GMT

You can replace below piece of set analysis in your expression

[Manufacturing date]={">=$(=date(max([Manufacturing date])-30)"}

Remove [Manufacturing year]={$(vCurrentYear)}, [Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}

Re: Variable for Days

Anonymous — Mon, 31 Aug 2015 04:14:53 GMT

Hi Kush,

Thanks for the first one

can you please provide me the 2. month before = last 30 days to last 60 days

Re: Variable for Days

jagan — Mon, 31 Aug 2015 04:58:02 GMT

HI,

Try like this

[Manufacturing date]={">=$(=date(max([Manufacturing date])-60)<=$(=date(max([Manufacturing date])-31)"}

Hope this helps you.

Regards,

jagan.

Re: Variable for Days

Kushal_Chawda — Mon, 31 Aug 2015 05:58:47 GMT

try below set expression

=Sum({<[Manufacturing date]={">=$(=date(max([Manufacturing date])-60))<=$(=date(max([Manufacturing date])-31))"},[Manufacturing year]=,[Manufacturing month]=>}PosMenge)

Re: Variable for Days

qlikviewwizard — Mon, 31 Aug 2015 07:25:56 GMT

Hi,

Please use the below expression.

sum({<[Manufacturing date]={"<=$(=date(max([Manufacturing date])-60))"}>}SAL)

Re: Variable for Days

jagan — Mon, 31 Aug 2015 10:22:40 GMT

Hi,

Did you tried this

=Sum({<[Manufacturing year]=, [Manufacturing month]=, [Manufacturing date]={">=$(=date(max([Manufacturing date])-60)<=$(=date(max([Manufacturing date])-31)"}>} PosMenge)

Hope this helps you.

Regards,

jagan.