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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Creator
Creator

Creating Flag Alert number of products

Hello, 

I have an issue, can you help please ? 

I have a list of products (say 1000 products) and their associated prices.

We receive the files every day, and they're stored in monthly QVDs.

One day, we didn't receive the prices for almost all the products, which skewed the analyses.

I want to create a flag or alert, with the following condition:

If for more than 50% of the products we receive each day, we don't have associated prices, then Red Flag.

Is it possible ?

Thanks for your help !

@vikasmahajan @kaushiknsolanki  @edwin  

Labels (4)
2 Replies
NiTo
Creator
Creator

Hi,

Interesting question and I also would like to see the answer for this one. Hope you get the reply soon.

vinieme12
Champion III
Champion III

can you clarify the scenario please

 "If for more than 50% of the products we receive each day, we don't have associated prices"

 

1) Does this means the Product Exists in the QVD, but the Price Field is Blank ?

OR

2) The Product itself is missing from the QVD entirely for that day?

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.