topic Re: Help me in correcting the expression? in QlikView

Help me in correcting the expression?

hemanthaanichet — Thu, 17 Aug 2017 09:55:06 GMT

Hi Guys ...

Here is the expression which give correct value only for 2017 Jan rest of the month are not correct

kindly help me on this.......

=num(((

(sum({<PCPM_Version_Desc = {'Adjustment','Actual'},PCPM_SalesType_Key={'1'},PCPM_SalesPeriod = {1},PCPM_Year=p(Year),PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_CP_Team_Flag={'CP','RPL','ORG'},PCPM_Day_Number_In_Month=p({<Day_Number_In_Month = {'<=$(=max(PCPM_Day_Number_In_Month))'}>}),PCPM_Day_of_Week=p({<Day_of_Week=>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}PCPM_Sales_Value))/1000

)

count({<PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}DISTINCT (PCPM_FFName))

count({<PCPM_Month=p(Month),PCPM_Calendar_Month=p({<Calendar_Month={'<=$(=max(Calendar_Month))'}>}),PCPM_RegionDesc={'*'},PCPM_AMHQCode=>}DISTINCT (PCPM_Month))),'#,##0')

Regards

Hemanth

Re: Help me in correcting the expression?

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:58:36 GMT

Do you select any thing from Day_Number_In_Month

Re: Help me in correcting the expression?

hemanthaanichet — Thu, 17 Aug 2017 10:08:11 GMT

No Anil.. in selection Year & month...

actually i start doing this for my previous thread

https://community.qlik.com/thread/270911

Re: Help me in correcting the expression?

hemanthaanichet — Thu, 17 Aug 2017 10:09:53 GMT

Can you have any idea r suggestion ????

Re: Help me in correcting the expression?

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:11:59 GMT

May be data was wrong when it comes to my mind because if one month data getting correct could be the reason for that months you may getting more that 1 frequency? Can you check the frequency in List box for that measure?

Re: Help me in correcting the expression?

hemanthaanichet — Thu, 17 Aug 2017 10:24:48 GMT

I checked it both are correct...

Actually i created two datamodels first is the main one and second one the same as first with change of column names