Discussion Board for collaboration related to QlikView App Development.
Hi All ,
I Have below Table . Need to achieve Exp1 & Exp2
Exp1 - Based on Article number where there is change in "Value " difference shud occur else 0
Exp2 - If change in number then Need Flag TRUE or FLASE
If possible : When User clicks on TRUE i need to show 1 previous Value in order to check how much was previous month Value
Advance Thanks all
I gave it a try in the attached qvw. The output looks like this.
View solution in original post
Cool thanks a lot it worked !!
Also thanks for quick response 🙂
Hi Vegar / Partner ,
As you suggested i was trying the same thing in my real data set , its slightly different . Help me out . It is based on each Year Month peek ( Note Month Starting shud be 0 for each Article Number )
I was able to achieve in front end :
if(YearMonth=min(total <ArticleNumber> YearMonth),0,sum(Value)- above(sum(Value))
Data below ( Want to achieve Exp1)
ArticleNumber , YearMonth ,Value , Exp1FSR0457, 2019-03 , 0,0FSR0457, 2019-04, 0 ,0
FSR0457,2019-05,50,50FSR0457, 2019-06 ,80, 30FSR0458 ,2019-03 ,0, 0FSR0458 ,2019-04 ,0, 0FSR0458 ,2019-05 0, 0