Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Opening Stock

Hi friends,

I want to show opening stock value

for example if i click on month Jun the opening stock value should be the value of may 31.

In text box am able to get the crct value but if i take that in pivot table with month dimension it is not showing the correct value

14 Replies
lalitkgehlot89
Creator II
Creator II

Hi Gowtham,

Please provide sample data.

ajsjoshua
Specialist
Specialist

Hi Bro,

How many dimensions you are using in pivot.

when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc.





gautik92
Specialist III
Specialist III
Author

Hi bro  ajsjoshua

sorting is not the problem now i want to shoe opening stock value

gautik92
Specialist III
Specialist III
Author

See the attachment

ajsjoshua
Specialist
Specialist

Hi Bro,

share ur expression.

gautik92
Specialist III
Specialist III
Author

I have shared the application da check t

MayilVahanan

Hi

Try like this

PICK(Match(%EXPRESSIONS,'OPENINGSTOCKNETWEIGHT','OPENINGSTONEWEIGHT'),

if(GetSelectedCount(SalesFY)>0 and GetSelectedCount(Month)>0,

  $(=Sum({<PURCHASERETURNDATE={"$(=Date(Min(NumDate)-1))"},Day=,Month=,SalesFY=>}StockNETWEIGHT)),

  Sum({<SalesFY={$(=Max(SalesFY))},StockDateNum={"$(=Floor(MonthEnd(StockDateNum,-1)) )"},Month=>}StockNETWEIGHT)),

Implement this in every expression logic

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
gautik92
Specialist III
Specialist III
Author

in if first expression is working fine

second one is not working

gautik92
Specialist III
Specialist III
Author

if month & year is selected it is working fine.if i clear it is not working