If then condition Qlik Sense

[#1]

Hello -

I have a simple Oracle table which I pulled into Qlik Sense. the columns are structured as below:

VERSION	MONTH	AMOUNT
ACTUAL	JAN	100
ACTUAL	FEB	200
PLAN	JAN	80
PLAN	MAR	90

In Qlik Sense I am trying to use a table and create a measure for Actual as a column and one for the plan using if condition in a measure calculation. This is how I want to see it:

VERSION	MONTH	ACTUAL	PLAN
ACTUAL	JAN	100	80
ACTUAL	FEB	200	0
PLAN	MAR		90

I am using the following calculation under 'measure' in Qlik Sense:

if (VERSION_ID='ACTUAL', Sum(AMOUNT), 0) for the Actual column and

if (VERSION_ID='PLAN', Sum(AMOUNT), 0) FOR PLAN column but

I don't get any numbers calculating. What am I missing? Please help.

Thanks!!

[lironbaram · Accepted solution]

first

try to change to

sum(if (VERSION_ID='ACTUAL', AMOUNT, 0) )

sum(if (VERSION_ID='PLAN', AMOUNT, 0) )

[#3]

Thank you!!! That worked Thank you so much.

[MarcoWedel]

Hi,

you could also use a generic load in the script to create the table you described.

hope this helps

regards

Marco

[MarcoWedel]

In QlikView it could look like:

Generic
LOAD MONTH,
    VERSION,
    AMOUNT
FROM [http://community.qlik.com/thread/145658] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

[MarcoWedel]

and in Qlik Sense:

Generic LOAD
     MONTH,
     VERSION,
     AMOUNT
FROM [lib://QlikCommunity_Thread_145658] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

[#7]

Marco -

This works! Thank you so much for the help.

[MarcoWedel]

You're welcome.

If you like , you can mark helpful in case it helped you.

Thanks

Regards

Marco

[#9]

I looked to mark it helpful but can't find it. Can you please let me know how to mark the response helpful?

Thanks!!

[MarcoWedel]

Hi,

when logged in, there should be this button available in your threads:

regards

Marco