topic Re: Concatenate If-String (Recommendations) in QlikView

Concatenate If-String (Recommendations)

nesonica — Sat, 16 Nov 2024 21:04:24 GMT

Hi guys,

I am trying to build a text-string that CONCATENATES every if-statement which leads to a result as follows:

// Customer no more online
if([Online % Pos.VJ]>0 and [Online % Pos.]<=0
,'Customer no more online'
,
// Customer online activated
if([Online % Pos.VJ]<=0 and [Online % Pos.]>0
,'Customer online activated'
,
// Less Positions online
if([Differenz Pos.]<0
,'Less Positions online'
,
// EDI-interface no more working
if([EDIUmsatz]<=0 and [EDIUmsatzVJ]>0
,'EDI-interface no more working'
,''))))

Please show me a way to rebuild this formula so that there will be a text-string like "EDI-Interface no more working, customer no more online". Currently only one single result of each is being shown.

Optional: I would also like to add a function where the person who sees the "recommendation text" can just switch it off and write a comment on it. Do you have an idea how to do that?

Thanks a bunch!

Nes

Re: Concatenate If-String (Recommendations)

Shubham_Deshmukh — Thu, 11 Apr 2019 10:44:33 GMT

Try this :

=if([Online % Pos.VJ]>0 and [Online % Pos.]<=0
,'Customer no more online')&','&
if([Online % Pos.VJ]<=0 and [Online % Pos.]>0
,'Customer online activated')&','
&
if([Differenz Pos.]<0
,'Less Positions online')&','
&
if([EDIUmsatz]<=0 and [EDIUmsatzVJ]>0
,'EDI-interface no more working')

Re: Concatenate If-String (Recommendations)

Shubham_Deshmukh — Thu, 11 Apr 2019 10:45:41 GMT

Change the sequence as per your requirement.

Re: Concatenate If-String (Recommendations)

nesonica — Thu, 11 Apr 2019 11:07:27 GMT

Very well, thank you! 😄 Only all the commas in case of no recommendations may be disturbing. If you find a way to avoid them, just update me.

Re: Concatenate If-String (Recommendations)

Shubham_Deshmukh — Thu, 11 Apr 2019 11:13:22 GMT

Sorry, I didn't get your OPTIONAL part of question, hope you are talking about the same.
Please elaborate a little.

Re: Concatenate If-String (Recommendations)

nesonica — Thu, 11 Apr 2019 11:19:51 GMT

Our sellers shall see recommendations about their customers, if an issue occurs.
But if the seller fixed the issue, he shall be able to "check off" the recommendation and "write a comment" to it that goes live. Is there any option for this?

Re: Concatenate If-String (Recommendations)

Shubham_Deshmukh — Thu, 11 Apr 2019 11:24:03 GMT

Sorry buddy, no idea

Re: Concatenate If-String (Recommendations)

sunny_talwar — Thu, 11 Apr 2019 11:33:36 GMT

You can may be look into making it an Inputfield