topic Re: Help on Set analysis in QlikView

Help on Set analysis

apegahfar — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am trying to use below function as expression in a straight table

=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

but it doesnt work

however without '-1' it works

please help

regards

Re: Help on Set analysis

rahulpawarb — Tue, 08 Aug 2017 11:27:01 GMT

May be this:

=Count({<PeriodCode={"$(=Num(FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))))-1)"}>}Period)

Along with this, could you please check what below function is returning? This will help you to identify the root cause.

=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))

Hope this will be helpful.

Regards!

Rahul Pawar

Re: Help on Set analysis

Anil_Babu_Samineni — Tue, 08 Aug 2017 11:28:30 GMT

Let's assume

FieldIndex('Period', GetFieldSelections(Period)) -- 4 // Assuming, you are selecting 4th record from Period Table

FieldValue('PeriodCode', 4) -- ABC // May be 4th place of PeriodCode is ABC

Then how you need ABC - 1 ???

Re: Help on Set analysis

tresB — Tue, 08 Aug 2017 11:33:23 GMT

If you are looking for the earlier indexed value count of the field, you may try with a bracket correction like:

=Count({<PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))-1))}>}Period)

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 11:58:46 GMT

Dear Rahul Pawar

thank for your reply

unforetunately it didnt wotk

i checked (=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period))))

it works

regard

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 12:10:55 GMT

Dear Anil Babu Samineni

thank for your reply

the Format of PeriodCode is number. as a resault FieldValue('PeriodCode', 4) return number not string

i checked (FieldIndex('Period', GetFieldSelections(Period))-1 )

it works correctly

regard

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 12:19:11 GMT

Dear Tresesco

thanks for your reply

i try that

it didnt work unfortunately

regard

Re: Help on Set analysis

Anil_Babu_Samineni — Tue, 08 Aug 2017 12:19:27 GMT

Will you able to provide work file to test?

Re: Help on Set analysis

PrashantSangle — Tue, 08 Aug 2017 12:20:46 GMT

Can you provide sample apps???

Regards,

Re: Help on Set analysis

Colin-Albert — Tue, 08 Aug 2017 12:41:27 GMT

Can you add the expression to your table as a new column with no label.

Then if you hover over the column header you can see how the variables in your set expression are being evaluated, which may help identify the problem.

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 12:55:02 GMT

here you are

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 12:56:40 GMT

here you are

Re: Help on Set analysis

tresB — Tue, 08 Aug 2017 13:00:19 GMT

Try like:

=Count({<Period,PeriodCode={$(=FieldValue('PeriodCode',FieldIndex('Period',GetFieldSelections(Period)))-1)}>}Period)

Re: Help on Set analysis

Anil_Babu_Samineni — Tue, 08 Aug 2017 13:03:31 GMT

May be ignore Selections using Period and i got as 398?

Re: Help on Set analysis

apegahfar — Tue, 08 Aug 2017 13:07:40 GMT

Dear Tresesco

it works correctly

thanks a lot