Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

Hi Gowtham,

Please provide sample data.

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.





Specialist III
Specialist III

Hi bro  ajsjoshua

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

Specialist III
Specialist III

See the attachment

Specialist
Specialist

Hi Bro,

share ur expression.

Specialist III
Specialist III

I have shared the application da check t

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
Specialist III
Specialist III

in if first expression is working fine

second one is not working

Specialist III
Specialist III

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