change expression to faster calculation expression

jagannalla — Fri, 06 Jul 2012 15:15:17 GMT

Hello All,

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

Column1	Column2	Column2	Column3
A	10	50	90
B	20	60	100
C	30	70	110
D	40	80	120

- 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

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?

Re: change expression to faster calculation expression

Sat, 07 Jul 2012 13:48:24 GMT

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 ';'

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

HtH

Roland

topic change expression to faster calculation expression in QlikView

change expression to faster calculation expression

Re: change expression to faster calculation expression