Measure

[aditya_pratap]

Hi Everyone

@Michael_Tarallo @mbj @petter @richbyard @Mp3Leaks @rohitk1609 @Marcus_Spitzmiller @ergustafsson @Masaki_Hamano @Sue_Macaluso 

if I am writing this Fx()=if(((max(week))-1,1000)

then I am getting 1000 value but if I am using measure or column name instead of 1000

for example: if(((max(week))-1,value) (here value is a measure.)

then I am getting (-) instead of value. Please help me in this problem.

[JordyWegman]

Hi Aditya,

Can you add your QVF maybe to show us what you are doing? Thanks!

Jordy

Climber

[aditya_pratap]

Hi I am sharing excel file in this we have 4 week and 2 columns in each week and at dimensionality 1 we have GL and at dimensionality 2 we have lob and at dimensionality 3 we have cat. So here I am trying to get week on week for (OO V)/(Total V) percentage. for example if we select all weeks in week filter then the current week will be 30 and pervious week will be 29 and we need to calculate (OO V)/(Total V) for week 30 - (OO V)/(Total V) for week 29 and we need percentage difference . And if we select only one week in week filter then current week will be that week only but previous week will be week-1.

Please help me in this I am new to qlik.

Thanks 

Aditya 

[JordyWegman]

HI Aditya,

I guess  you also have a non pivot format of you data right?

Jordy

Climber