Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
HAmzehAF
Partner - Creator
Partner - Creator

im not getting data in the charts

im using the data analysis

---------------------------------------------------------------------------------------
1-(count({< Date={"$(=max(Date))"}, Stock={"<=5"}>} distinct TopSku)

/
Count({<Date={"$(=max(Date))"}>} DISTINCT TopSku))  " 

---------------------------------------------------------------------------------------
to get the avaliblity for the topsku with 5 or less items in the store/div/supp/group..... ,


and this is my two tables im using here 
---------------------------------------------------------------------------------------

stock : 

Daily_Stock:
LOAD
DT,
PRODUCT ,
DESCRIPTION,
PRODUCT as sku,
Price,
WAC,
"DIV",
Division,
GRP,
"Group",
CTG,
SubGroup,
BRAND,
STORE_ID as TRXH_LOC_CODE,
Stock,
if(Stock<=5 and Stock>0,'1','0') as AVb_Stock,

 

---------------------------------------------------------------------------------------

 and for the topsku : 
TopSKU:
LOAD
ITEM_CODE as PRODUCT,
TopSku,
if(TopSku<=5 and TopSku>0,'1','0') as Avb_TopSku

--> item code is the topsku ,

---------------------------------------------------------------------------------------

put when i use the set analysis  im not getting anything expects for the chart called store but the rest nothing anyhelp with this ?>

 

 

0 Replies