Convert to set analysis

Wed, 14 May 2014 05:25:27 GMT

Hello guys,

I have the following expression

SUM(IF(YEAR(OrderBacklogContractedPostingDate)=YEAR(CYear) AND MONTH(OrderBacklogContractedPostingDate)>MONTH(MAX(CDate))
       ,IF(ISNULL(OrderBacklogContractedAmount) OR OrderBacklogContractedAmount=''
           ,0
           ,OrderBacklogContractedAmount)))

How to change this to set analysis?

Thank you for your kind attention guys

Re: Convert to set analysis

jagan — Wed, 14 May 2014 06:17:09 GMT

Hi,

Try like this, arrive Year dimension in script for OrderBacklogContractedPostingDate and CYear, and Month dimension for OrderBacklogContractedPostingDate

Now in set analysis try this

=SUM({<OrderBacklogContractedPostingDate_Year)= P(CYear_Year), OrderBacklogContractedPostingDate_Month = {'>$(=MONTH(MAX(CDate)))'}>}
Alt(OrderBacklogContractedAmount, 0))

Replace OrderBacklogContractedPostingDate_Year, CYear_Year and OrderBacklogContractedPostingDate_Month with your new fields arrived in script.

Regards,

Jagan.

topic Convert to set analysis in QlikView

Convert to set analysis

Re: Convert to set analysis