topic Re: To Calculate Repeated Calls in QlikView

To Calculate Repeated Calls

Mon, 15 Jul 2013 04:31:22 GMT

Hi,

I actually want to calculate the serial no which are repeated. I do not have a repeat flag, I need to create a repeat flag in the back end/script to calculate the repeat calls, I am unable to do the count function in the script to calculate the repeat calls. Can someone help on this issue?????

Re: To Calculate Repeated Calls

sivarajs — Mon, 15 Jul 2013 05:29:30 GMT

you can find in table also

use something like sum(aggr(if(count(FieldA)>1,1,0),FieldB))

Re: To Calculate Repeated Calls

Mon, 15 Jul 2013 05:44:33 GMT

Hi,

Thanks for ur response. Actually i do not have 2 different fields. I have one field serial no . I want to calculate the serial no repeated in the backend because i want to categorize this like

for eg:

if once repeated as spare call

2nd repeated as additional spare

3rd time non spare etc.

Is it possible to do could u pls help on the same??

Re: To Calculate Repeated Calls

Mon, 15 Jul 2013 06:01:17 GMT

hi,

thanks for the response,

I do not 2 fields here to calculate, I have only 1 field serial no. I need to write this in backend because i need to calculate the ratio of repeated calls. I want something like this

if call is repeated for first time- 'Spare'

if call is repeated for second time- additional spare

if call is repeated for third time- it is a non spare

can u pls help me on this???

Re: To Calculate Repeated Calls

sivarajs — Mon, 15 Jul 2013 06:04:13 GMT

Try this example

Load *,if(Previous(SerialNo)=SerialNo,1,RangeSum(1,peek(flag))) as flag ;

LOAD * Inline [

SerialNo

];

Then in front end create a staight table

Add dimension as your serial no and expression as count(flag)

Re: To Calculate Repeated Calls

kaushiknsolanki — Mon, 15 Jul 2013 06:31:09 GMT

Hi,

You can create a new table which will have the Serial number and its occurance count.

So the script will be.

Load Distinct Serial_No,count(Serial_No) as Count

From xyz

Group by Serial_No.

Regards,

Kaushik Solanki