Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
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.
Hi Daniel, please attach a sample so I can check it out, tx, S
Hi,
this could be a part of your load-script:
Load
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"
Regards
Roland
Hi Daniel,
Here's the sample table that solves your problem.
Regards
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.
Thanks anyway!
kurokarl, I will try this out.
Thank you for your quick response!
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??
Thanks,
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.
See you
Roland
Hi,
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.
Thanks,