Discussion board where members can learn more about Qlik Sense App Development and Usage.
I manage several facts type in same table. Those facts share some properties in another table and one type of facts is linked to the other by a pivot table.
- A fact is linked to B fact
- A fact and B fact share some properties
I would like to create a KPI or representation of difference between all A and B linked.
A and B have common properties :
I would like to count the qty of A who has not the same value for name, ref and price than linked B...
My schema is :
[Fact] : contains all A and B facts
Fact_Type (A or B)
[Fact_properties] : contains all properties of facts
[Pivot_AB] : create link between fact A and B
I succeed to create table representing each propertie for two types :
But now, I want to create a KPI representing the consistency rate between A and B, so the number of facts A not consistent with linked B facts.
Can you share a QVF? That would be a bit easier.
The data load script is very complex (5 layers to load), so I created an simple example