Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have an issue where I list (in some cases) two "owners" of one document, one as the primary and one as the secondary. I would like to combine this so that when in Qlik Sense, there is less of a distinction, and I can recognize that the secondary owner still is that asset owner (without having to list primary and secondarily owned assets).
Example:
I would like to be able to measure that Jeff owns 2 assets. As of now, we have a count of assets as the measure of Asset owner 1, which is not giving a full scope of workload.
If there is an easier way to do this with a function in Qlik Sense it is welcome.
I'm not sure to undestand what you want, however:
crosstable(OwnerType,Owner,1)
load Document,[Asset Owner 1],[Asset Owner 2] resident YourTable;
you so obtain a table with this schema
Document, OwnerType, Owner
ABC Datasheet, Asset owner 1, Meg
ABC Datasheet, Asset owner 2, Jeff
DEF Datasheet, Asset owner 1, Jeff
so you can count easier for your measure.
best regards
Thank you,
Where in the data load editor would this code go? I'm new to qlik sense. Would I write it in before the table that includes the Asset owner fields, or after?
Also, how would I phrase 'document'? What would that be.
Thank you so much!
Take a look here :
Another little sample :
/* Load of raw data with MonthYear in column (Jan2014,...)*/
Orders_raw:
LOAD *
INLINE [
Product,Jan2014, Feb2014, Mar2014, Apr2014
A,100,190,234,345
B,98, 234, 267, 349
];
/* Load with cross table prefix wich allow to tranform your matrix */
Orders_final:
Crosstable (Month, Sales) LOAD Product, [Jan2014],[Feb2014],[Mar2014],[Apr2014]
resident Orders_raw;
/* Drop the raw data became useless */
DROP Table Orders_raw ;
And in the message of Edmundo, document is just the field name of the first column (equivalent to Product in my example).