Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sateeshkumar
Creator
Creator

Filter on metrics (expression) in straight table

Hi,

I have requirement to display straight table. Which is having 15 dimensions and 18 metrics. We have totally 100 million records/3 Years data. I have implemented the above. But the problem with the filter on metrics. They want 4 filters either by input box or sliders. Straight able has to display rows which are greater than selected value in slider.

     Here i am getting issue with implementing filters. I have to keep 4 "If else" conditions (for each slider value) on all the metrics (18 metrics). Which affects the straight table performance.

     The table is having metrics like previous 3/6 months qty,3/6months sales, 3/6 motnths savings.. like that. And among those 6 metrics are calculating based on input box. So i cant move all the metrics to script. I can move only few metrics to script and make as dimension, after that i have to create calculated dimension to apply filter, which is again having performance issue. Please suggest me to solve this problem.

0 Replies