Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
first
try to change to
sum(if (VERSION_ID='ACTUAL', AMOUNT, 0) )
sum(if (VERSION_ID='PLAN', AMOUNT, 0) )
first
try to change to
sum(if (VERSION_ID='ACTUAL', AMOUNT, 0) )
sum(if (VERSION_ID='PLAN', AMOUNT, 0) )
Thank you!!! That worked Thank you so much.
Hi,
you could also use a generic load in the script to create the table you described.
hope this helps
regards
Marco
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
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
Marco -
This works! Thank you so much for the help.
You're welcome.
If you like , you can mark helpful in case it helped you.
Thanks
Regards
Marco
I looked to mark it helpful but can't find it. Can you please let me know how to mark the response helpful?
Thanks!!
Hi,
when logged in, there should be this button available in your threads:
regards
Marco