topic Re: Calculation in QlikView

Calculation

Mon, 11 Jun 2012 18:49:46 GMT

i have calulated visit as per month Sum({<[month]={$(vmonth)}>}[visit])

but i want to calculate visit as per month as well as type.

that is visit of type abc,yre,cam,dec,others.

can i calculate change of visit by type as per month in same grapth.

i have attached excel sheet and qvw.

Wed, 13 Jun 2012 19:15:25 GMT

Any responce any body

Wed, 13 Jun 2012 22:13:34 GMT

Hi,

Did you try adding type as a second dimension in your chart in the attached example?

If this is not what you are looking for, could you pls. rephrase your question?

regards,

Thu, 14 Jun 2012 05:46:55 GMT

i have done as second dimension,but i have to show avg of type group ,without using dimension.

any other metod to do this.Sum({<[month]={$(vmonth)}>}[visit]) in this expression how can i add type,this will helpful.

jagan — Thu, 14 Jun 2012 07:51:27 GMT

Hi Shantnu,

Try Aggr like this

=Avg({<[month]={$(vmonth)}>}Aggr(Sum({<[month]={$(vmonth)}>}[visit]), month, type))

Hope this helps you.

Regards,

Jagan.