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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

change expression to faster calculation expression

Hello All,

I'm loading 4 fields from my database. Say for example:

Column1Column2Column2Column3
A105090
B2060100
C3070110
D4080120

- Now i want to convert column2,column3,column4 as filter. So i'm taking inline load, so i can get new column with all my column names.

SourceData
Column2
Column2
Column3

- Now i'll take Column1 as dimension & column2,column3,column4 as my expression in line chart. And also i'm taking SourceData in one listbox.

- When i select column2 from sourcedata listbox then the line chart should show column2 along with column1, Same for column3,column4. By default chart should show all columns data.

I'm using qv11, we can give condition for expression. So i'm giving for each expression condtion as shown below.

column1  -> =If(GetSelectedCount(SourceData)=0 ,True(),If(SubStringCount(GetFieldSelections(SourceData,',','*'),'Column1')>0,True(),False()))

column2  -> =If(GetSelectedCount(SourceData)=0 ,True(),If(SubStringCount(GetFieldSelections(SourceData,',','*'),'Column2')>0,True(),False()))

column3  -> =If(GetSelectedCount(SourceData)=0 ,True(),If(SubStringCount(GetFieldSelections(SourceData,',','*'),'Column3')>0,True(),False()))

- Every thing is working fine according to my task. But the chart is taking lot of time to render for each selection. How can i make it fast?

1 Reply
Not applicable

Hi Jagan,

try in your condition expression the concat()-function. This should be faster.

For ex. column1 try these:

Concat(SourceData,';') = 'column1'     // should work also without ';'

or

Concat(SourceData) like '*column1*'  //to let user select more than one col at a time

HtH

Roland