topic Re: count month in QlikView

count month

Anonymous — Tue, 29 Sep 2015 04:10:15 GMT

hi,

i want to make expression that calculte "Monthly percentage orders".

but when i write "=count(DISTINCT(yearmonth))" , i get only the peirod that have orders.

for exm.

aaa order in feb & april , whan i chose month jan-may ( 5 month) ,

i need to culculte 2/5= 40%.

how do i count month without consider the dimension ?

thanks'

yarin.

sunny_talwar — Tue, 29 Sep 2015 04:13:06 GMT

how do i count month without consider the dimension ?

Try this:

=Count(DISTINCT TOTAL yearmonth)

sunny_talwar — Tue, 29 Sep 2015 04:13:54 GMT

And to calculate the percentage, try this:

=Count(DISTINCT yearmonth)/Count(DISTINCT TOTAL yearmonth)

Anonymous — Tue, 29 Sep 2015 04:18:21 GMT

thanks'

but it's look the same.

distinct total does't work as i need.

sunny_talwar — Tue, 29 Sep 2015 04:19:13 GMT

Can you share the some sample data with expected output?

SreeniJD — Tue, 29 Sep 2015 04:20:10 GMT

Hi Yarin,

Set an Order flag =1 for order month and 0 for missed month, and use the below expression..

=Sum({<OrderFlag={1}>} 1) / (Sum({<OrderFlag={1}>} 1)+sum({<OrderFlag={0}>} 1))

There is always better ways to do this

HTH,

Sreeni