topic Re: How Could I do this ratio? in QlikView

How Could I do this ratio?

ecabanas — Fri, 14 Dec 2012 12:50:22 GMT

I have this example table:

SalesId CustomerID date

1 A jan-12

2 B Jan-12

3 C Jan-12

4 A Feb-12

I want to know the number of salesId which has ben bough two times

count({<SUM(count(SalesID))>=3>} CustomerID)

thank's to all

Re: How Could I do this ratio?

Fri, 14 Dec 2012 12:58:43 GMT

i didn't get you properly.. plz describe briefly what you actually want to do....

Re: How Could I do this ratio?

ecabanas — Fri, 14 Dec 2012 13:01:01 GMT

I want to know, how many customers has been bought two times, in my example: 1

The customerID: "A" has bought two times, the rest only one!!!

Re: How Could I do this ratio?

Fri, 14 Dec 2012 13:12:20 GMT

CustomerID	count(SalesId)
A	2
B	1
C	1

step --1-- use pivot table

step 2-- take dimension CustomerID

step 3-- add expression count(SalesId)

hope this will help you

Re: How Could I do this ratio?

ecabanas — Fri, 14 Dec 2012 13:25:40 GMT

Hi!!

This will not be possible, I need this number in a text box, has to be a function!!

Sent from my iPhone

Re: How Could I do this ratio?

Fri, 14 Dec 2012 13:43:55 GMT

in which sheet object you want to see the output.?????

text box mean ?

Re: How Could I do this ratio?

ecabanas — Fri, 14 Dec 2012 15:30:47 GMT

yes, in text box

Re: How Could I do this ratio?

Mon, 17 Dec 2012 08:59:32 GMT

see the attached image.

hope this will help you..

Re: How Could I do this ratio?

ecabanas — Mon, 17 Dec 2012 09:11:14 GMT

YES, and how you did it?

How you filter the pivot and how you conect the pivot cell with the text box?

Thank's

Eduard

Re: How Could I do this ratio?

Mon, 17 Dec 2012 09:40:56 GMT

Hi,

As I understand you query, you are trying to find out how many CustomerID have purchased more than twice.

This cant be done using a a function in a text box. Max you could do is, display the count of the number of time the selected customer has purchased.

I have compiled an QVW with an example of how you could do it.

Let me know if this is what you are looking for, else let me know you exact query with sample data

thanks

Fahad

Re: How Could I do this ratio?

Mon, 17 Dec 2012 11:26:14 GMT

create new text object and in text write

=Count(SalesID)

you dont need to filter

see the attached image

Re: How Could I do this ratio?

ecabanas — Mon, 17 Dec 2012 11:45:44 GMT

Hi Fahad,

Thank you for your compiled example, but oone question, what is the "RepeatedTime" in the function?

it does not calculate correctly

Re: How Could I do this ratio?

Mon, 17 Dec 2012 11:59:31 GMT

Hi,

The "RepeatedTime" is the field Name which calculates the number of time the customer has purchased.

It is a new filed created in the Script.

for example CustomerID = "A" has made 4 purchases, the script counts and stores it in the field "RepeatedTime" for all the instanses of CustomerID = "A" in data.

You could look into the script..

Thanks

Re: How Could I do this ratio?

ecabanas — Mon, 17 Dec 2012 14:50:11 GMT

You are the ONE!!!

Thank's!!! if you come to Barcelona you are invited to a beer 🙂