topic Re: Calculation Problem in QlikView

Calculation Problem

khasimvali85 — Tue, 07 Oct 2014 06:54:30 GMT

Hi COmmunity,

Could you Please find the what the problem Here? In Call column not displaying exact values

Count	CompNo	Call
7	JOD0108130227 : JOD0108130244 : JOD0108130296 : JOD0208130006 : JOD0208130024 : JOD0208130024 : JOD0208130164	1 : 1 : 1 : 1
2	KAR0108130079 : KAR0108130142	1 : 1
1	SAN0108130225	1
3	KOL0108130073 : KOL0108130127 : KOL0108130275	1 : 1
14	LUC0108130124 : LUC0108130172 : LUC0108130180 : LUC0108130181 : LUC0108130214 : LUC0108130214 : LUC0108130227 : LUC0108130235 : LUC0208130013 : LUC0208130057 : LUC0208130159 : LUC0208130207 : LUC0208130250 : LUC0208130293	1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1 : 1

Regards

Khasim.

Re: Calculation Problem

anbu1984 — Tue, 07 Oct 2014 06:57:15 GMT

What is Call column?

Can you attach sample qvw.

Re: Calculation Problem

pandiarajan — Fri, 10 Oct 2014 09:45:02 GMT

Dear Khasim,

Plz send the exact expression what u are using here

Re: Calculation Problem

khasimvali85 — Fri, 10 Oct 2014 10:09:14 GMT

Hi Pandiarajan,

Thanks for replying in my Table i couldn't given the right Expression means date field couldn't given so its not showing right values,when i given right date field the expression working fine now.

The Expression is given below:

=Concat(

If(

AGGR(

SUM({< CallDate=,DataDate=,FetchDate=,DATEField={'$(=vVariableName)'} >}CALLS),COMP_NO)>=3,COMP_NO),' : ')

Regards,

Khasim.

Re: Calculation Problem

Fri, 10 Oct 2014 10:39:23 GMT

Can you please close the question by marking relevant answers as correct or helpful

Thanks,

Singh

Re: Calculation Problem

pandiarajan — Fri, 10 Oct 2014 11:18:59 GMT

great my dear go ahead

Re: Calculation Problem

khasimvali85 — Fri, 10 Oct 2014 12:08:10 GMT

Dear Pandiarajan,

Thanks Pandiarajan sure i will go through.

Regards,

Khasim.