topic Re: Back End Script Help in QlikView

Back End Script Help

kiranpatil123 — Sat, 16 Nov 2024 03:00:17 GMT

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 no	Date	Value	Exp1	Exp2
1	18-Jan	20	0	FALSE
1	18-Feb	20	0	FALSE
1	18-Mar	20	0	FALSE
1	18-Apr	25	5	TRUE
1	18-May	25	0	FALSE
2	18-Jan	100	0	FALSE
2	18-Feb	100	0	FALSE
2	18-Mar	100	0	FALSE
2	18-Apr	104	4	TRUE
2	18-May	104	0	FALSE

Advance Thanks all

Re: Back End Script Help

Vegar — Mon, 15 Jul 2019 14:23:09 GMT

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

Re: Back End Script Help

kiranpatil123 — Mon, 15 Jul 2019 14:54:59 GMT

Cool thanks a lot it worked !!

Also thanks for quick response 🙂

Re: Back End Script Help

kiranpatil123 — Mon, 15 Jul 2019 18:02:18 GMT

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