Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nesonica
Contributor III
Contributor III

Concatenate If-String (Recommendations)

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

Labels (4)
1 Solution

Accepted Solutions
Shubham_Deshmukh
Specialist
Specialist

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')

View solution in original post

7 Replies
Shubham_Deshmukh
Specialist
Specialist

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')
Shubham_Deshmukh
Specialist
Specialist

Change the sequence as per your requirement.
nesonica
Contributor III
Contributor III
Author

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.
Shubham_Deshmukh
Specialist
Specialist

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

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?
Shubham_Deshmukh
Specialist
Specialist

Sorry buddy, no idea
sunny_talwar

You can may be look into making it an Inputfield