topic Re: QuestionQuestion in QlikView

QuestionQuestion

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to write an if statement to only show Quarantined Inventory. Wanting to separate it from the total inventory count. I'm either getting an 0 or a number higher than my current inventory count. Below is my current if statement and how I populate inventory. Any and all help will be most welcomed.

If( [InvHistory Transaction Type] = 'Quarantined' , $(InventoryQuantity) , 0)

sum({$< [Inventory Date] = {"<=$(=date(max(Date)))"},
Year={*},
Period={*},
Date={*},
Month={*},
[Calendar Year] = {*},
[Inventory Status Code] -= {1},
[LinkId]={"INVHSTD"}
>}
[InvHistory Transaction Quantity])

Re: QuestionQuestion

johnw — Wed, 02 Nov 2016 17:15:00 GMT

Perhaps just add this to your set expression?

[InvHistory Transaction Type]={'Quarantined'},

Re: QuestionQuestion

Oleg_Troyansky — Wed, 02 Nov 2016 18:18:23 GMT

Just to clarify John's response - you can't ask this question outside of your sum(). Instead, you should either ask it inside the SUM(), or better off, add it as another filter in your set analysis condition.

cheers,

Oleg Troyansky

Learn advanced Qlik techniques in my book QlikView your Business

Re: QuestionQuestion

Wed, 02 Nov 2016 19:09:25 GMT

Thank you guys for helping. This is how I solved it. Used [Inventory Quarantined] ={'Quarantined'}, .

sum({$< [Inventory Date] = {"<=$(=date(max(Date)))"},
Year={*},
Period={*},
Date={*},
Month={*},
[Calendar Year] = {*},
[Inventory Status Code] -= {1},
[Inventory Quarantined] ={'Quarantined'},
[LinkId]={"INVHSTD"}
>}
[InvHistory Transaction Quantity])