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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Comparison

Hi Community,

PFA,

Please anyone give some suggestions.............

Regards,

Paul

3 Replies
Anonymous
Not applicable

Paul

Could you clarify what you mean by show count of ALERT , as I can see no field called ALERT in your data model.

Best Regards,     Bill

paulwalker
Creator III
Creator III
Author

Hi Bill,

Alert means already i calculated field in my STRAIGHT table

Actually i want to show alerts count.... and Comparison with MonthlyCoverage and ActualDemand

Anonymous
Not applicable

Paul


You could create a field called Alert in your load script :


If ([Actual Demand]>[Monthly Coverage] ,Dual('Alert',1) , Dual('Ok',0))     as Alert ,

Then simply use the Sum() function to give you the count :

Sum ( [Alert] )

If you are not familiar with the Dual function, then look it up in the Help.

Best Regards,    Bill