topic Re: Set Analysis LYQTD error in QlikView

Set Analysis LYQTD error

jayshrinipurte — Fri, 05 Jan 2018 04:36:16 GMT

Hi Experts,

Please Help...

=num(sum({<[Sales Organization]={'1000'},[G/L acc. no.]={' ','','31010100','31010300'},[Customer Group]={'01'},[Category]={'F & F Blends-Special'},[Fin Year]=,[Cal Year]=, Month=, [Cal Quarter]=, Day=,

BillingDate_Num ={">=$(=num(QuarterStart(AddYears(Max({<Date_Flag={'ZSales'}>}BillingDate_Num),-1)))) <=$(=num(AddYears(Today(),-1)))"}

>}[GL Value])/10000000,'#,##0.00')

This Expression giving me Zero value...

Re: Set Analysis LYQTD error

prma7799 — Fri, 05 Jan 2018 04:49:24 GMT

Try this

BillingDate_Num={">=$(=(QuarterStart(AddYears(Max({<Date_Flag={'ZSales'}>}BillingDate_Num),-1)))) <=$(=num(AddYears(Today(),-1)))"}

Re: Set Analysis LYQTD error

neha_shirsath — Fri, 05 Jan 2018 05:41:20 GMT

Try this

SUM(Month=, Quarter=, Year=, BillingDate_Num={">=$(=date(QuarterStart(Today(),-4))) <=$(=date(QuarterEnd(Today(),-4)))"}[GL Value])

Re: Set Analysis LYQTD error

sunny_talwar — Fri, 05 Jan 2018 09:43:13 GMT

It could be because you have no data that meet the criteria which is why you see 0? I mean just by looking at the expression it would be very difficult to know why you are getting a 0. Do you want to may be share more information? Or share a sample and explain what the expected output should be?