topic Set identifiers in a If statement in QlikView

Set identifiers in a If statement

Fri, 13 Jun 2014 11:46:40 GMT

Hi Everybody,

I am a new QlikView developper and I have a problem.

I load data in which there are three columns. The first column is registration_date and the second one is treatment_date and the last one is number_of_folder.

I would like to sum the number_of_folder column every time where registration_date equal treatment_date.

To do it I first wrote this statement :

Sum( If([registration_date] = [treatment_date], [number_of_folder] )

But I didn't work. I noticed that It's just because I had selected a range for registration_date and treatment_date both using a slider and It wasn't what I should do. I have to evaluate this activity without taking in account the selected treatment_date (It's used for another operation) but by using the selected registration_date

So, I try this statement where I try to specify the full data set using Set Analysis statement by hoping that in the If Statement, the comparaison between the two column date will be base from the full data set not from the data set obtained after selecting date but it doesn't work.

Sum( {1<[registration_date] = P([treatment_date]), [treatment_date]={"*"}>} If([registration_date]=[treatment_date], [number_of_folder]) )

Please how could I do it ? Thanks.

Re: Set identifiers in a If statement

tresB — Fri, 13 Jun 2014 11:52:55 GMT

Try:

=Sum( {< [treatment_date]=>} If([registration_date]=[treatment_date], [number_of_folder]) )

Re: Set identifiers in a If statement

Fri, 13 Jun 2014 11:53:25 GMT

Sum({<[number_of_folder]={" [registration_date] =[treatment_date]" }>} [number_of_folder])

Re: Set identifiers in a If statement

teempi — Fri, 13 Jun 2014 11:57:07 GMT

Hi,

I would create a new field in the script, something like this:

If([registration_date] = [treatment_date], [number_of_folder], 0) AS NewField

Then just sum that field up as usual and it should work.

-Teemu

Re: Set identifiers in a If statement

Fri, 13 Jun 2014 14:19:17 GMT

Hi tresesco,

Thanks but no changes. I get the same results with my statements.

Re: Set identifiers in a If statement

Fri, 13 Jun 2014 14:20:52 GMT

Hi Srashti,

Thanks but it doesn't work. I don't know how the statment works but it gives a result very far from the good result.

Re: Set identifiers in a If statement

Fri, 13 Jun 2014 15:32:34 GMT

Yes Its a good answer but I couldn't apply this because there are many indicators to calculate based on the same logic. So, just imagine I apply it in a large data sets.