topic Re: Removing ValueList ? in QlikView

Removing ValueList ?

Fri, 09 May 2014 11:25:02 GMT

Hi All,

I need some help in removing the ValueList from chart dimension and as well from expression in Case 2 like in Case 1.

Please find the sample attachment for your reference.

Thanks in advance..

Regards ,

Ravikumar

Gysbert_Wassenaar — Fri, 09 May 2014 11:29:25 GMT

Use Month as dimension and this expression:

pick(match(Month,vPrevMonth,vCurrMonth),

Sum({<Month={"$(vPrevMonth)"}>}Sales)/4,

Sum({<Month={"$(vCurrMonth)"}>}Sales)/10

)

Fri, 09 May 2014 11:36:03 GMT

Hi Wassenaar,

Actually I am doing this change to improve the performance.

Your solution is also looking similar to ValueList.Will it effective than using ValueList ?

Regards ,

Ravikumar

Gysbert_Wassenaar — Fri, 09 May 2014 11:42:31 GMT

I think so. Test it to make sure.... as always 🙂