Automatic field selection

[#1]

Hi all,

I have the following problem.

I have a data report , when I select there a specific field value, there is another field which is selected  automatically too.

I don't want this additional field to be selected because , when I add values to my first selection the unwilled automatic selection limits the results.

What do I have to do in order to stop the unwilled automatic selection?

For example in the file attached, I chose Seat RA, I did not choose PPublisherName, so why is it chosen anyway?

Thanks ,

Inna

[Caique_Zaniolo]

Can you send a sample (QVW) with the Actions you are using?

[#3]

Hi,

if you want to avoid that that field doesn't disturb an expression you could use set analysis adding:

{$<Field=>}

for instance

Sum({$<Field=>} Field2)

Hope it helps

Regards

Giampiero

[#4]

Hi,

I am attaching my qvw here.

Thanks a lot.

Inna,

[#5]

Hi Giampero,

can you please see qvw which I attached in my answer to Caique? Can you help me to implement your advise in code which I have in the model:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

TempNetworkDomainData:

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_ADX_4_2_2013.qvd

(qvd);

concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_RA_4_2_2013.qvd

(qvd);

Thanks a lot.

Inna.

[#6]

Hi Inna,

that way I mentioned before is a set analysis way to implement in your expressions.

You write:

"... when I select there a specific field value, there is another field which is selected  automatically too."

Can you tell as the fields involved in this problem.

FIELD 1 selected IS ?  ... and  ... FIELD2 automatically selected IS ??

Best regards

Giampiero

P.S: I have your qlikview doc.

[#7]

Hi Giampero,

When I choose field Seat, a field PPublisherName is selected automatically.

So where do I have to put the expression you wrote according the code I sent?

Thanks a lot,

Inna.

[#8]

Hi Inna,

try to put in the expressions where you don't want to have yhe influence of PPublisherName ,

{$<PPublisherName =>}

I think it should work.

If this behaviour influences all your document (so all the expressions of your document) you have to modify your script in some way.

regards

Giampiero

[#9]

Hi Giampero,

tried it, but it relly did not help.

Thanks,

Inna.

[#10]

Hi,

could you please tell me where you have tried (sheet, chart and expression)

So I can do the same wih your qvw.

Giampiero