I have a table that looks like the one below:
Cue IncommingCalls AnsweredCalls
Sales 5 4
Support 3 2
What I would like to do is adding a field that displays a 0 if the value of the Cue field is support.
It would then look like this:
Cue IncommingCalls AnsweredCalls AnsCalls-Support
Sales 5 4 4
Support 3 2 0
There is probably an easy solution to this but I'm a beginner when it comes to QlikView.
I'm guessing that it might be possible to solve this with load inline.
this could be a part of your load-script:
Cue, // and other fields
If ( Cue='Support', 0, AnsweredCalls) AS [AnsCalls-Support],
// next fields, if any
--> creates a new field called "AnsCalls-Support" during load, content depending on the field "Cue"
Hi shanejvv, unfortunately I'm still running the Personal Edition version on my computer and from what I understand you can't open .qvw files that are created with a PE-license on another computer.
I will hopefully get a proper license within the coming weeks but I hope I have sorted this out by that time.
Unfortunately, we do not have option to insert fields either left or right to use some functions in Qlikview 8 th version.
Is such kind of option is there in latest version??
Hi Tim (Daniel),
I do not understand your comment. Do you both work in the same office ? To answer your question: My (load-)solution works fine with 9.x And as far as I remember the old QV8-days, it should work also with that version.
I am talking general, let assume you have one table box, if you want to add one more field its not that much feasible as compared to Business objects.