Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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?
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