topic Re: Selection Status in QlikView

Selection Status

Anonymous — Fri, 01 Apr 2016 11:57:48 GMT

Hi,

When exporting data from QlikView to Excel, it is possible to display a Selection Status. This feature is quite useful, but there is one issue which I want to fix somehow.

Let me explain.

In my model there are two tables: Table1 and Table2 which are not connected to each other.

Table1 includes the fields: T1_FieldA, T1_FieldB, T1_FieldC, T1_FieldD, T1_FieldE.

Table2 includes the field T2_FieldA.

I have created a chart based on the fields T1_FieldA, T1_FieldB. Then I published the application on the server and exported the data to excel. Then I see that the selection status in Excel-file includes the selections made in the fields T1_FieldA, T1_FieldB. But the selection made in the field T2_FieldA is not displayed in selection status section.

Is it possible to tune the application in such a way that the selection in the field T2_FieldA will be included in a Selection Status?

Thank you in advance,

Larisa

Re: Selection Status

swuehl — Fri, 01 Apr 2016 12:05:04 GMT

If these tables are not linked in the data model, does a selection in table2 influence your chart results somehow?

Re: Selection Status

swuehl — Fri, 01 Apr 2016 12:10:45 GMT

I got the output if I added a field reference to the other table somewhere in the chart expressions, like

Sum(Value)+(Count(Name)*0)

Value is a field from table1 and Name a field from table2, both tables not linked

OrderDate	Sum(Value)+(Count(Name)*0)
	527,6449445
01/01/2014	36,38141202
02/01/2014	46,32751774
03/01/2014	21,67963865
04/01/2014	70,00389351
05/01/2014	68,79202747
06/01/2014	71,99359261
07/01/2014	89,59690565
08/01/2014	42,58632027
09/01/2014	80,28363655

Selection Status:
OrderDate: 9 of 1000
Name: E:\Users\Stefan\Downloads\ALL.qvd, E:\Users\Stefan\Downloads\bm_test.qvd, E:\Users\Stefan\Downloads\Files.qvd, E:\Users\Stefan\Downloads\Fuel_Transaction.qvd, E:\Users\Stefan\Downloads\Historie.qvd

Re: Selection Status

Anonymous — Fri, 01 Apr 2016 13:33:21 GMT

Thank you!