topic Re: I want to change this into a set analysis expression in QlikView

I want to change this into a set analysis expression

robinwiman — Fri, 05 Oct 2018 06:58:26 GMT

Hi,

I had this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'} >} If(WildMatch(SeasonCalc, vCurrentSeasonCalc) and [Year Week]>= vYearWeek_YD, Order_Budget_Qty))

changed it into this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"} >} If([Year Week]>= vYearWeek_YD, Order_Budget_Qty))

Now trying to do this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {">=$(=vYearWeek_YD)"} >} Order_Budget_Qty)

But the last expression does not work. If I remove the >= it means that I will only get the current week, and I need the current week + all the future ones as well.

Any ideas? Thanks

Re: I want to change this into a set analysis expression

andrey_krylov — Fri, 05 Oct 2018 07:05:03 GMT

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {"$(='>=' & vYearWeek_YD)"} >} Order_Budget_Qty)

Re: I want to change this into a set analysis expression

robinwiman — Fri, 05 Oct 2018 07:07:34 GMT

There's no error in the expression, however, the table comes out blank

Re: I want to change this into a set analysis expression

andrey_krylov — Fri, 05 Oct 2018 08:48:46 GMT

In fact, both expressions do not have syntax errors, this

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {">=$(=vYearWeek_YD)"} >} Order_Budget_Qty)

or this

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {"$(='>=' & vYearWeek_YD)"} >} Order_Budget_Qty)

Can you attach a sample? Or check the values of vYearWeek_YD and [Year Week].

Re: I want to change this into a set analysis expression

sasiparupudi1 — Fri, 05 Oct 2018 11:24:49 GMT

Try

Sum(

[Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'},

SeasonCalc = {"$(=vCurrentSeasonCalc)"} ,

[Year Week]={">=$(=vYearWeek_YD)"}

Order_Budget_Qty)