topic Re: Analysis Help in QlikView

Analysis Help

tgumbing — Thu, 16 Nov 2017 09:33:52 GMT

Hi,

In my example I nedd Help

I want to calculate "SalesClosed in Sales Month"

Thanks for your help

Thanks

shraddha_g — Thu, 16 Nov 2017 09:35:03 GMT

What is your data?

What you are expecting as a output.

Can you please elaborate

prma7799 — Thu, 16 Nov 2017 09:39:54 GMT

Missing comma in your second expression

=sum({<SalesYear=,SalesMonth=,SalesClosedYear={$(=max(SalesYear))}, SalesClosedMonth=,SalesMonth>} SalesClosed)

If this is not fulfill your requirement then please share expected output.

stabben23 — Thu, 16 Nov 2017 09:40:09 GMT

Hi Thomas,

Is this gives you correct output?

=sum({<SalesYear=,SalesMonth=,SalesClosedYear={$(=max(SalesYear))}>} SalesClosed)

tgumbing — Thu, 16 Nov 2017 10:35:52 GMT

I want this :

The column "SalesClosed in Sales Month" calculate the number of sales who

SalesClosedYear=SalesYear and fror each SalesMonth=SalesClosedMonth

I want to bring the number of clodedSales in the month Sales.

tgumbing — Thu, 16 Nov 2017 10:37:13 GMT

I want this :

The column "SalesClosed in Sales Month" calculate the number of sales who

SalesClosedYear=SalesYear and fror each SalesMonth=SalesClosedMonth

I want to bring the number of clodedSales in the month Sales.

Anonymous — Fri, 17 Nov 2017 08:22:38 GMT

Hi,

maybe something like this :

sum({<SalesYear={$(=max(SalesYear))}>} if(SalesMonth=SalesClosedMonth,SalesCounter,0))