Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if I have a column inital_inv and first row has data and second row data will come
Initial Inv
200
-
-
-
-
Demand
50
20
60
30
Initial_inv-Demand
I need the output
200
150
130
70
40
How can i achive. Please help me.
Thanks,
Nishant
You probably would need to use Peek() vs Previous() – When to Use Each to get this done. Here is another place you can read about it: Peek() or Previous() ?
For more detailed help, I would suggest you to provide a sample where we can see your data model to help you better
Hello Sunny,
I have only one initial_inv as per Material code. Giving full example.
Material
M1
M1
M1
M1
M2
M2
M2
Initial Inv
200
Demand
50
20
60
30
Output need
200
150
130
70
40
How this subtract will happen durning running the dashborad in qliksense.
Thank you for helping me.
Thanks,
Nishant
Hello Sunny,
I got the result.. Thank you for helping me.
Now one more help i need.
I've a columns
Step 1
1
1
1
1
1
0
0
1
1
1
1
1
I need output like
Step 2
5
4
3
2
1
0
0
5
4
3
2
1
How can i count in reverse order and avoid the 0
thanks,
Nishant
Hi Nishant,
Are You expecting this ?
5
4
3
2
1
On what basis it should be scripted ?
Hello,
Yes, But need to write the expression in qliksense.
Can you provide me the solution .
Thanks,
Nishant