Set Analysis Using Result of a column

alucard_ae86 — Sat, 16 Nov 2024 20:23:16 GMT

Hello Experts,

I am trying to create an expression with set analysis that uses result of another column and a variable.
So I have a column that has DD/MM (compareDate) and i would like to concatenate this with a variable equals to /YYYY (vYear) and use it in a Set Analysis Expression . I am using the following Coding but it does not seem to work

Sum({$<BWVORG={'000','001','004','005','006','010'},BWAPPLNM={'MM'},BWBREL={1},BUDAT={"<=$(=Ceil(Concat([compareDate]&vYear))) "}>}BWMNG_KAR)

Any Suggestion ?

Thank you in advance

Re: Set Analysis Using Result of a column

tresB — Thu, 25 Jul 2019 09:09:19 GMT

To concatenate two strings you used '&'. I guess you don't need concat() which is an aggregation function. Also, I could not understand why you used ceil(). Try to share a sample app with an explanation of expected output.

topic Re: Set Analysis Using Result of a column in QlikView

Set Analysis Using Result of a column

Re: Set Analysis Using Result of a column