topic Re: Need to merge two status in QlikView

Need to merge two status

Wed, 07 Jan 2015 12:10:58 GMT

Hi All,

I have 4 status (PFA) . I want to merge 2 status. The status is a field from DB . Is it possible to use any function in expression? or is there any other way ?

Re: Need to merge two status

its_anandrjs — Wed, 07 Jan 2015 12:15:16 GMT

Hi,

In the load script you can do it like

Ex:-

LOAD Status,

if(Match(Status,'A','B'),'AB',Status) as NewStatus;

LOAD * Inline [

Status

D ];

Or In front end you can try

if(Match(Status,'A','B'),'AB',Status)

Note:- Check suppress when value is null option.

Regards

Anand

Re: Need to merge two status

pho3nix90 — Wed, 07 Jan 2015 12:36:59 GMT

What do you mean you want to merge them? Do you not want them split up in the chart? If so remove the dimension. If you want to string together 2 fields then do =FieldName1 & ' ' & FieldName2

Re: Need to merge two status

Wed, 07 Jan 2015 13:10:31 GMT

Cool that was really helpful

Re: Need to merge two status

Wed, 07 Jan 2015 13:15:43 GMT

FYI Small correction in the front end I need put single quotes for the status for the status I am merging for and AB is the name of the legend name.