topic Re: Automatic field selection in QlikView

Automatic field selection

Tue, 05 Feb 2013 15:31:30 GMT

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

Re: Automatic field selection

Caique_Zaniolo — Tue, 05 Feb 2013 15:41:05 GMT

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

Re: Automatic field selection

Tue, 05 Feb 2013 16:29:38 GMT

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

Re: Automatic field selection

Wed, 06 Feb 2013 08:29:49 GMT

Hi,

I am attaching my qvw here.

Thanks a lot.

Inna,

Re: Automatic field selection

Wed, 06 Feb 2013 08:38:07 GMT

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.

Re: Automatic field selection

Wed, 06 Feb 2013 08:57:08 GMT

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.

Re: Automatic field selection

Wed, 06 Feb 2013 09:00:31 GMT

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.

Re: Automatic field selection

Wed, 06 Feb 2013 09:46:10 GMT

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

Re: Automatic field selection

Wed, 06 Feb 2013 10:18:58 GMT

Hi Giampero,

tried it, but it relly did not help.

Thanks,

Inna.

Re: Automatic field selection

Wed, 06 Feb 2013 11:54:21 GMT

Hi,

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

So I can do the same wih your qvw.

Giampiero

Re: Automatic field selection

Wed, 06 Feb 2013 12:02:35 GMT

Hi,

In tab Heavy analysis you have expressions - Impressions,Clicks etc.,

So in Sum expressions I put for example, Sum({$<PPublisherName=>} BuyerImpressions) instead of sum(BuyerImpressions) and so on.

Would appreciate very much if you could help me.

Thanks,

Inna.

Re: Automatic field selection

Caique_Zaniolo — Wed, 06 Feb 2013 12:39:36 GMT

Inna, you are using a Calculated Dimension in your Cyclic Group based on the Publisher Name, that is the reason we get some selections on the PPublisherName field.

Re: Automatic field selection

Wed, 06 Feb 2013 12:44:16 GMT

Hi, I understand.

Can I leave this calculation and avoid the situation, or I need another solution for the calculation?

Thanks,

Re: Automatic field selection

Caique_Zaniolo — Wed, 06 Feb 2013 12:51:50 GMT

You could create the field on the script using the if statement you have and then use the field you created in the cyclic group.

Re: Automatic field selection

Wed, 06 Feb 2013 13:32:30 GMT

Hi,

I followed your advise and everything works is it should!!!

Thanks a lot,

Inna.

Re: Automatic field selection

Wed, 06 Feb 2013 13:33:59 GMT

Hi giampiero,

I followed Caique answer and everything is excellent now.

Thanks,

Re: Automatic field selection

Wed, 06 Feb 2013 14:54:31 GMT

Hi Inna,

Caique found a very good solution.

Happy for you

Regards

Giampiero