Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
fagologp
Contributor
Contributor

Expression issue

Hi,

I have a table with date, model, category, to send, KPI Ref, and Stock.

I need to perform a calculation with these conditions:

  • Numerator: KPI Ref=X, to send>0 and  stock=0
  • Denominator: KPI Ref=X, to send>0

All these fields only depends on the model, date and Category ignoring the colour.

If a model for a date and category has a color with a stock other than 0, it will not count in the numerator.

A model for a date and category must have an 'X' in the KPI Ref field in at least one of the colors so that they meet the condition in both the numerator and the denominator.

A model for a date and category must have a value greater than 0 in the field to send in at least one of the colors so that they meet the condition in both the numerator and the denominator

The last four columns of the excel are the expected output for the numerator, denominator and the calculation for each model and the total calculation.

I attach the excel and the app with the table and the KPI with tests that I have done.

Regards.

0 Replies