topic Re: Creating a Column based on a condition in App Development

Creating a Column based on a condition

Sat, 27 Feb 2016 03:44:40 GMT

Hi,

I have loaded some columns in Qlik Sense Desktop which are:

"Date",
Description,
"Short Description",
Segment,
"Sub Segment",
"Transaction Value",

Segment has values like Home and Entertainment.

I want to create another column where the columns is named "Home" and the values are from Transaction Value IF the Segment contains Home. Hopefully this table makes it clear.

Segment

Transaction Value

Home (new column)

Entertainment (new column)

Home

$100

Entertainment

$200

Entertainment

$300

Home

$400

$100

Any help here would be appreciated.

Re: Creating a Column based on a condition

Sat, 27 Feb 2016 10:17:38 GMT

In your Home field put :

if(Segment='Home',[Transaction Value],'')

Re: Creating a Column based on a condition

sunny_talwar — Sat, 27 Feb 2016 11:05:23 GMT

Try this:

LOAD "Date",

Description,

"Short Description",

Segment,

"Sub Segment",

"Transaction Value",

If(Segment = 'Home', "Transaction Value") as Home

If(Segment = 'Entertainment', "Transaction Value") as Entertainment

FROM Source;

Re: Creating a Column based on a condition

Gysbert_Wassenaar — Sat, 27 Feb 2016 18:11:14 GMT

You can create extra fields in the script as Sunny showed above. You can also use three expressions in a straight table with Segment as dimension:

sum([Transaction Value])
sum({<Segment={'Home'}>}[Transaction Value])
sum({<Segment={'Entertainment'}>}[Transaction Value])

Re: Creating a Column based on a condition

Sun, 28 Feb 2016 00:08:03 GMT

Thanks Sunny,

This worked perfectly. You're a legend.

Re: Creating a Column based on a condition

Sun, 28 Feb 2016 00:08:42 GMT

Thanks Gysbert,

This seems to work as an alternative as well. Appreciate your help as well.

Thanks a lot

Delzad