topic Several question about QlikView 9 in QlikView

Several question about QlikView 9

Fri, 14 May 2010 09:21:23 GMT

Several question about QlikView 9 (QV9)

1. I want to get data from several SQL Server and ORACLE servers.
But in Edit Script of QV9 I can put only 1 declaration "CONNECT TO [Provider=...];".
How do I get several connections?

2. I use TableBox and click (select) one Row or Column.
How can I get the Row and/or Col numbers and Cell value (text)?

3. I use TableBox and RowCount is variable (it depends on selection in others boxes).
How can I get current RowCount of TableBox?

Re. :Several question about QlikView 9

martin59 — Fri, 14 May 2010 10:00:16 GMT

Hello,

1. You can have several ODBC connections by clicking on the ODBC or OLEDB connection button (Edit script) to declare them. When you click on Select button, you can change your database on top of the window (data source).

2. If I understood, you can use the "Only()" or "GetFieldSelections()" functions.

3. You can count numbers of distinct values for the concatenation of all fields shown in your tableBox.

Regards,

Martin

Re. :Several question about QlikView 9

Fri, 14 May 2010 13:00:25 GMT


Martin Favier wrote:
1. You can have several ODBC connections by clicking on the ODBC or OLEDB connection button (Edit script) to declare them. When you click on Select button, you can change your database on top of the window (data source).

Thanks! I understand.


Martin Favier wrote:
2. If I understood, you can use the "Only()" or "GetFieldSelections()" functions.

Unfortunally I cannot find in manual function "Only()".
Could you get more information concerning it.


Martin Favier wrote:
3. You can count numbers of distinct values for the concatenation of all fields shown in your tableBox.

Ok!
I try explain on the real sample:
How do I use QV9 functions for show in TableBox Title current RowCount?

I try so
= 'RecordCount (Count: ' & Count ($Rows) & ' - ' & RowNo(TOTAL) & ')'
but got wrong information

Re. :Re: Re. :Several question about QlikView 9

martin59 — Fri, 14 May 2010 13:23:39 GMT


Vlad wrote:Unfortunally I cannot find in manual function "Only()".
Could you get more information concerning it.

extract from the help file :

<h4>only( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ]expression)</h4>
If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.
 <h2>Examples</h2><table><tbody><tr><td>
only( Sales )</td></tr><tr><td>
only( Price*Quantity )</td></tr><tr><td>
only( total Salesman )</td></tr></tbody></table>


Vlad wrote:I try so
= 'RecordCount (Count: ' & Count ($Rows) & ' - ' & RowNo(TOTAL) & ')'
but got wrong information

Is that returns a value ???

if you have a tableBox with 4 fields : field1, field2, field3 and field4. You have to do that :

Count(Distinct field1&'_'&field2&'_'&field3&'_'&field4)

Martin