topic Re: Which set exp is correct in these ?? in QlikView

Which set exp is correct in these ??

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

1.count({< SE_MARK={1},$1>}DISTINCT SERVICE_ID) or count({$1< BASE_MARK={1}>}DISTINCT SERVICE_ID)

- which is correct in above 2 exp

2. var name is vCustomerBase_Exp

vCustomerBase_Exp = count({< SE_MARK={1},$1>}DISTINCT SERVICE_ID)

$(vCustomerBase_Exp(CHARGE_CODE={'*_RP_*'})) -- is this correct.

Please respond if any idea on the above, Thanks in advance.

Re: Which set exp is correct in these ??

karthikoffi27se — Wed, 10 Jan 2018 11:17:45 GMT

HI Vishal,

The second expression is correct count({$1< BASE_MARK={1}>}DISTINCT SERVICE_ID)

I am not getting your second question

Thanks

Karthik

Re: Which set exp is correct in these ??

Anil_Babu_Samineni — Wed, 10 Jan 2018 11:20:59 GMT

For second one, Do you have Parameter analysis?

Re: Which set exp is correct in these ??

vishalgoud — Wed, 10 Jan 2018 11:30:52 GMT

Hi Anil , Thanks for response ,

yes even am also new to project , but CHARGE_CODE there are different records out of which we are taking only those which are having _RP_ in that. hope this is a parameter analysis.

but i suspect that syntactically the below is wrong, can you please help on this.

$(vCustomerBase_Exp(CHARGE_CODE={'*_RP_*'})) -- is this correct

Re: Which set exp is correct in these ??

Anil_Babu_Samineni — Wed, 10 Jan 2018 11:34:55 GMT

What you shown equation that is correct. Instead Single Quote try to use Double Quote?

Re: Which set exp is correct in these ??

vishalgoud — Wed, 10 Jan 2018 11:36:22 GMT

Thanks for the response,

there is no harm using the first one as well right.. count({< SE_MARK={1},$1>}DISTINCT SERVICE_ID)

this was used in many exp. So just asking ?

Re: Which set exp is correct in these ??

jonathandienst — Wed, 10 Jan 2018 11:36:31 GMT

Your vCustomerBase_Exp is a parameterised 'macro'. the $1 will be replaced buy the first parameter when the variable is expanded with $(.....)

$(vCustomerBase_Exp(CHARGE_CODE={'*_RP_*'})) will expand to

count({< SE_MARK={1},CHARGE_CODE={'*_RP_*'}>}DISTINCT SERVICE_ID)

which is a syntactically valid expression. To evaluate, you may need to nest the expansion

$($(vCustomerBase_Exp(CHARGE_CODE={'*_RP_*'})))

Do not confuse the $1 used for the parameter with $ used as the current selection set in the set expression. The $1 as a set selector in the second expression will use the previous selection. Its like seeing the results of clicking the sections "Back" button.

Re: Which set exp is correct in these ??

vishalgoud — Wed, 10 Jan 2018 12:06:47 GMT

Thank you Jonathan.

if i get you correctly -

there was no syntax errors here

count({< SE_MARK={1},$1>}DISTINCT SERVICE_ID) - correct one only.

vCustomerBase_Exp = count({< SE_MARK={1},$1>}DISTINCT SERVICE_ID) results in

count({< SE_MARK={1},CHARGE_CODE={'*_RP_*'}>}DISTINCT SERVICE_ID) which is also correct , Thanks again.