topic Re: how to write it in QlikView

how to write it

Thu, 19 Jun 2014 12:08:53 GMT

I have too much raw data . I want to get a range's sales. I set the following range as a dimension:

if(date(sale_date)-date(prod_date)<=30,'sal_30',if(date(sale_date)-date(prod_date)<=70,'sal_70',if(date(sale_date)-date(prod_date)<=120,'sal_120','other')))---------

I always get the error "allocation memory exceed." . Is there another method to get the result ?

Each product have own's fixed date. The sale's date have many date .

Re: how to write it

joshabbott — Thu, 19 Jun 2014 12:23:20 GMT

I would write your if statement in the script instead of in the dimension, bring back a column name with 'Range Sales'. This will also make your object quicker with refreshing changes.

Re: how to write it

Thu, 19 Jun 2014 12:31:15 GMT

I have different end-date that depend on user's selection . The range sales is different.

Re: how to write it

Anonymous — Thu, 19 Jun 2014 12:37:14 GMT

Hi,

Write this into a variable

vcalc:

=date(sale_date)-date(prod_date)

and in the expression write this expr

=if(S(vcalc)<=30,'sal_30',S(vcalc)<=70,'sal_70',S(vcalc)<=120,'sal_120','other'))

So that calculation is done only once instead of thrice.

Re: how to write it

Thu, 19 Jun 2014 12:51:19 GMT

=if($(vcalc)<=30,'sal_30',$(vcalc)<=<=70,'sal_70',$(vcalc)<=<=120,'sal_120','other'))--- can't work. what is S meaning ?

the <=<= can't work .

Re: how to write it

Thu, 19 Jun 2014 16:00:16 GMT

what is the error?

The S means $ I think its a typographical error?

Is date_prod a variable, or a selection from a data Island?

Re: how to write it

Thu, 19 Jun 2014 16:05:24 GMT

what is the error?

The S means $ I think its a typographical error?

Is date_prod a variable, or a selection from a data Island?

Re: how to write it

Fri, 20 Jun 2014 03:22:42 GMT

one product has only one prod_date: 20130105 b 20130203 c 20130407

but the sales date have many for every product .I want to get range sales like 30days,70days from prod_date untill user's selection monthes.