topic Re: TOTAL with set analysis in App Development

TOTAL with set analysis

lucasx15 — Thu, 02 Feb 2023 12:07:22 GMT

I have the following problem, I need to carry out a measurement of customers who purchased products in a period less than or equal to 30 days after leaving in relation to the total number of customers who access the site. Ignoring the defective products group, I am using the TOTAL attribute. But I'm having trouble applying it.

My dimension is: FL_RETURN. It is dimensioned contains:

1 - Up to 72 Hours 2 - Up to 15 Days 3 - Up to 30 Days 4 - Up to 45 Days 5 - Up to 60 Days

My expression:

COUNT({<CD_EXIT_ALT={12}, // where I consider the exits of a certain category IE_PRODUCT-={3,5}, // ignore defective products FL_RETURN={'1 - By 72 Hours'} // I put this test flag inside my analyze set >> TOTAL DISTINCT NR_CLIENT) / COUNT({<CD_EXIT_ALT={12}, IE_PRODUCT-={3,5} // ignore defective products >} DISTINCT NR_CLIENT)

Re: TOTAL with set analysis

agigliotti — Thu, 02 Feb 2023 14:08:25 GMT

Hi @lucasx15 ,

The TOTAL keyword is used to ignore all chart dimensions values.

Maybe this:

COUNT({<CD_EXIT_ALT={12},
IE_PRODUCT-={3,5},
FL_RETURN={'1 - By 72 Hours'}
>>
DISTINCT NR_CLIENT)
/
COUNT({<CD_EXIT_ALT={12},
IE_PRODUCT-={3,5}
>} TOTAL DISTINCT NR_CLIENT)

I hope this can helps.

Best Regards

Re: TOTAL with set analysis

lucasx15 — Thu, 02 Feb 2023 14:43:05 GMT

Hello, thank you very much for the answer and for the help.

I decided to insert all the fields of my expression in the set analysis of FL_RETURN.

It now looks like this:

FL_RETURN={' 1 - Up to 72 Hours',' 2 - Up to 15 Days', ' 3 - Up to 30 Days',' 4 - Up to 45 Days', ' 5 - Up to 60 Days' }

And I separated the expression into numerator and denominator. However, I couldn't understand why the values were the same in all rows and columns and I couldn't understand. Since it was for each line to have a different value. Sorry, it's because I'm new to Qlikview.

Re: TOTAL with set analysis

agigliotti — Thu, 02 Feb 2023 15:15:25 GMT

I guess you have to remove FL_RETURN={'1 - By 72 Hours'} from the numerator as below:

COUNT( {< CD_EXIT_ALT={12}, IE_PRODUCT-={3,5} >} DISTINCT NR_CLIENT )
/
COUNT( {< CD_EXIT_ALT={12}, IE_PRODUCT-={3,5} >} TOTAL DISTINCT NR_CLIENT)