Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
World be grateful if you can go through my below requirement and shed some light on the technical feasibility in QV
Objective is to Show the item availability across stores / brands etc.
Flow 1:
I understand that this can be very well achieved fixing date range while loading and pre populating the items with a flag to indicate if the stock exists or not.
My question is, is there a way to make this dynamic to give user an option to select any week on the UI?
Please let me know.
Hey Jayaprakash,
I would think that this can only be done on the front end as the user can select any input. Creating a flag on the back-end wont work.
I would create a variable that would calculate the appropriate date when W10 2014 is selected and then use that variable in the expression to find the rolling stock using set analysis.
ex:
Sum(<{Date={"<=$(vVariable)"}}>StockQuantity)
Hope it helps
Thanks
AJ
Hi AJ thanks for the reply .
in this case how do I get the total count of items with stock >0 ? is the above expression work when I summarize the item count at a higher level dimension ? say item count under a brand
May be you can add another expression like(The label for above expression is say StockQty):
Count(Distinct if(StockQty>0,Item#))
In table expressions you can use other expression labels in your calculations. This is a very effective way to calculate in cases like these.
is Count(Distinct if(StockQty>0,Item#)) work when i dont have item as dimension ?
Well you might have to aggregate it with Item#. Again its definitely doable.
These are all suggestions to show you how it can be done. When actually doing it you might have to change it as per needs.
Hi , if doable i am happy can you please guild me . a sample would do .
basically i want to know hot to 'aggregate it with Item#' as you said
Attached is an example.
Thanks
AJ
hey cant find the attachment