Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Back End Script Help

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 

Article noDateValueExp1Exp2
118-Jan200FALSE
118-Feb200FALSE
118-Mar200FALSE
118-Apr255TRUE
118-May250FALSE
218-Jan1000FALSE
218-Feb1000FALSE
218-Mar1000FALSE
218-Apr1044TRUE
218-May1040FALSE

 

Advance Thanks all

Labels (1)
1 Solution

Accepted Solutions
Vegar
Partner
Partner

I gave it a try in the attached qvw. The output looks like this.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Vegar
Partner
Partner

I gave it a try in the attached qvw. The output looks like this.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

kiranpatil123
Contributor III
Contributor III
Author

Cool thanks a lot it worked !!

Also thanks for quick response 🙂 

kiranpatil123
Contributor III
Contributor III
Author

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 , Exp1
FSR0457, 2019-03 , 0,0
FSR0457, 2019-04, 0 ,0

FSR0457,2019-05,50,50
FSR0457, 2019-06 ,80, 30
FSR0458 ,2019-03 ,0, 0
FSR0458 ,2019-04 ,0, 0
FSR0458 ,2019-05 0, 0