topic Set Expression in QlikView

Set Expression

upaliwije — Wed, 09 Mar 2016 07:11:38 GMT

Hi,

I have calculated Budget in my QV document with following expression

sum( {<NOTE = {'SALES'}>}[BUDGET] )

Now I want to increase this budget by 5% effective from the month of march. My current budget and revised amount is shown below

I want to rewrite the expression where budget should only be increased 5 % with effect from Mar onward

Pls let me how to modify the above expression

MayilVahanan — Wed, 09 Mar 2016 07:19:43 GMT

Try like this

= If(Month> 'Feb', sum( {<NOTE = {'SALES'}>}[BUDGET] ) + (sum( {<NOTE = {'SALES'}>}[BUDGET] ) *0.05), sum( {<NOTE = {'SALES'}>}[BUDGET] ))

upaliwije — Wed, 09 Mar 2016 08:09:15 GMT

THANKS

When I apply your expression it does not work for some months

eg:JAN,APR,AUG,DEC

Pls refer Attachment below

MayilVahanan — Wed, 09 Mar 2016 08:18:56 GMT

Try like this

LOAD *, MONTH(DATE#(MONTH, 'MMM')) AS MONTHNAME INLINE [

MONTH, Budget, REVISED_BUDGET,

JAN, "4,125,000", "4,331,250",

FEB, "4,025,000", "4,025,000",

MAR, "4,225,000", "4,436,250",

APR, "3,445,000", "3,445,000",

MAY, "4,225,000", "4,436,250",

JUN, "4,225,000", "4,436,250",

JUL, "5,125,000", "5,381,250",

AUG, "5,225,000", "5,225,000",

SEP, "5,725,000", "6,011,250",

OCT, "5,625,000", "5,906,250",

NOV, "5,350,000", "5,617,500",

DEC, "5,353,000", "5,353,000"

];

Revised = If(MONTHNAME > 2, sum( [Budget] ) + (sum( [Budget] ) *0.05), sum( [Budget] ))

original = Sum(Budget)