Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
robinwiman
Creator
Creator

I want to change this into a set analysis expression

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

4 Replies
andrey_krylov
Specialist
Specialist

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

robinwiman
Creator
Creator
Author

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

andrey_krylov
Specialist
Specialist

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].

sasiparupudi1
Master III
Master III

Try

Sum(

{<

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

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

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

>}

Order_Budget_Qty)