Measures in Qliksense LineChart

[vidyas16]

Dear All,

I have a metadata table which contains the list of rules and its different categories and subcategories. I have also a table 'RunRecs' that holds information on the list of rules that are executed on a particular date. My requirement is in a line chart the dimension should be the date, two measures should be displayed.

Measure 1-Run: List of rules executed on that date.

Measure 2-NoRun: List of rules not executed on that date.

Issue: My issue is Measure 2(No Run). Since  I am using the date as dimension ,the count(distinct Rules)  gives only Rules for that dimension.

Could someone please tell how  can I calculate

Count(distinct Rules) (this should give overall Rulecount) - Count({<recno={">=0"}>}distinct Rules) (Rules executed)

Thank you in advance.

Thanks and Regards,

Vidya S  

[vidyas16 · Accepted solution]

I think using the Total qualifier will fetch the results what I wanted.