I am using a Direct query approach since I have millions of data to work with and full load is not practical.
My Direct Query:
DIRECT QUERY
dimension
[cf_id],
[c_id],
[txt],
[file]
measure
1 as record_count
FROM table_x;
The Load was successful and I can do basic KPI with the data.
1) But the KPI doesn't yield correct result when I use set analysis. (Expression in KPI)
Example: (vWord1 is my input box variable)
=count(distinct {<file = p({<txt= {"*$(#vWord1)*"} >}) >} [c_id])
2) Also few qlik sense functions doesn't yield correct result. (Expression in Filter Pane)
=if(txt = vWord1, txt)