Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vsabbise
Creator
Creator

KPI and Filter Pane doesn't work with variable in the expression in Direct Query Approach

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)

 

 

Labels (2)
0 Replies