Subset Ratio

[New-Qlik]

I have requirement to  show subset ratio the one we get in data model into front end as a KPI or in nay form.

Thanks in advance

[Quy_Nguyen]

As my understanding, sankey chart is not suitable for this case because of the subset ratio principle.

I suggest using Venn Chart.

[rwunderlich]

Nice explanation and example ipcducquy‌!

-Rob

[New-Qlik]

hi Quy,

how do I insert flag column with one value throughout in a QS script for database column

[Quy_Nguyen]

Thank you for your compliment Rob!

[Quy_Nguyen]

Hi,

You can use preceding load with your SQL load statement. Below is just an example:

Customer:
LOAD

    [Customer Number]   

    Country,
    City,
    1 As CustomerFlag;
SQL SELECT [Customer Number]
    Country,
    City
FROM Customer ;

[New-Qlik]

Yes got it after posting . thanku