Creating values in a field based on values in two other fields

[#1]

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.

[#2]

Hi Daniel, please attach a sample so I can check it out, tx, S

[#3]

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

[#4]

Hi Daniel,

Here's the sample table that solves your problem.

Regards

[#5]

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!

[#6]

kurokarl, I will try this out.

Thank you for your quick response!

[#7]

Hi Daniel,

Can you access the file that I had uploaded?

If no just follow this instruction:

In your Expression add this code

If(Cue = 'Support', '0', AnsweredCalls)

Then on Presentation Tab, unchecked Suppress Zero Values.

Regards

[#8]

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,

[#9]

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

[#10]

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,