topic Re: using calculated dimension in QlikView

using calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

hi ,

I would like to build a graph to show a count if customer who has called in a certain amount of days from starting with the company . the formula I am using is avg(distinct(if(CallStartDt<BillDate,BillDate-CallStartDt))) . Now I want to use this a calculated dimension for a bar graph.

maybe I am missing something.

regards,

marvin

Re: using calculated dimension

sunny_talwar — Wed, 23 Nov 2016 14:06:13 GMT

May be like this

Dimension

Aggr(If(CallStartDt < BillDate, BillDate-CallStartDt), Customer)

Expression

Count(DISTINCT Customer)

Re: using calculated dimension

rupamjyotidas — Wed, 23 Nov 2016 18:26:03 GMT

Make a flag in Script

If(CallStartDt < BillDate,1,0) as Flag

Then

Dimension

Aggr(if(Flag=1, BillDate-CallStartDt),Customer)

Even Better if possible(depending on your datamodel)

If(CallStartDt < BillDate,BillDate-CallStartDt,'NA') as DateDiff

Then Dimension

Aggr(if(DateDiff<>'NA',avg(DateDiff)),Customer)

Re: using calculated dimension

Anonymous — Thu, 24 Nov 2016 04:40:03 GMT

Hi Marvin,

You can use following.

Dimension:- aggr(avg((if(CallStartDt<BillDate,BillDate-CallStartDt))),Customer)

Expression:- Count(DISTINCT Customer)

Thanks,