topic Group field values in IF statement in QlikView

Group field values in IF statement

Ricky16 — Sat, 16 Nov 2024 21:51:40 GMT

Hi everyone,

I'm new in qlikview and i have a doubt:
I have a field named Status and i have 3 distinct values (O, C, R), so i need to join O + R and give a name 'Open'. But i need to isolate Status as Open with just Open too. This is the script i have:
If(STATUS = 'O', 'Open', If(STATUS = 'C', 'Close', 'Reopen')) as Status

thanks

Re: Group field values in IF statement

sunny_talwar — Tue, 20 Nov 2018 12:50:24 GMT

A single row will say O + R, or this is across multiple rows? What is the common field we are checking O and R against?

Re: Group field values in IF statement

Ricky16 — Tue, 20 Nov 2018 12:57:25 GMT

In Status field i only have values 'O' (Open), 'R' (Reopen) and 'C' (Closed)

If status is O or R so it's 'Open' but if it's only R it need to be named as 'Reopen'

Re: Group field values in IF statement

sunny_talwar — Tue, 20 Nov 2018 13:04:37 GMT

But a single row can ever have O or R, right? Do you have a transaction id against which are checking this? Meaning

Transaction Status
123 O
123 R

so, now the Transaction 123 will be Open

Transaction Status
345 R

but transaction 345 will be Reopen?

Re: Group field values in IF statement

jonathandienst — Tue, 20 Nov 2018 13:09:54 GMT

It sounds like you need two fields. A single field in a record will not be able to reflect both conditions.

Re: Group field values in IF statement

avinashelite — Tue, 20 Nov 2018 13:17:48 GMT

Try like this : Create an new field with the inline load that should take care

LOAD * inline

[

Status , New_Status

O,Open

R,Open

R,Reopen

C,Closed

];

Now use the New_Status field that will server the purpose