Hello Qlik Community Members- this discussion has been answered previously but accidentally deleted we are recreating the thread. Here are the responses:
Correct Answerby toucangulyayu on Jul 24, 2013 7:36 AM
Actually, Evan, what I think you want to do is show the 'ANDMode' conditions for your secondary dimension or the field [2nd_Dim].
You don't need to change your data at all, you just have to build the ANDMode field off of your Fact table and not from your Organization table because I am guessing that you wanted to show in your pivot table organizations which associated with the colors 'Green', 'White', and 'Grey'.
Switch these two definitions and your application can then build a field off of [2nd_Dim] which uses 'AND Mode'.
(See attached).
Switch this
//[ANDModeTable]:
//LOAD DISTINCT
// ID,
// Org AS [Org ANDMode]
//RESIDENT Org;
with this
[ANDModeTable]:
LOAD DISTINCT
ID,
[2nd_Dim] AS [2nd_Dim ANDMode]
RESIDENT Fact;
---------------------------------------------------
Gysbert Wassenaar Jul 22, 2013 1:15 PM (in response to EvanKurowski)
There's only one Org for each ID value. In other words there are no ID's with more than one Org. So there's no AND possible. Try adding some more records into the Org table so that some some ID's have more than one Org.
-----------------------------------------------------
toucangulyayu Jul 24, 2013 7:36 AM (in response to EvanKurowski)
Actually, Evan, what I think you want to do is show the 'ANDMode' conditions for your secondary dimension or the field [2nd_Dim].
You don't need to change your data at all, you just have to build the ANDMode field off of your Fact table and not from your Organization table because I am guessing that you wanted to show in your pivot table organizations which associated with the colors 'Green', 'White', and 'Grey'.
Switch these two definitions and your application can then build a field off of [2nd_Dim] which uses 'AND Mode'.
(See attached).
Switch this
//[ANDModeTable]:
//LOAD DISTINCT
// ID,
// Org AS [Org ANDMode]
//RESIDENT Org;
with this
[ANDModeTable]:
LOAD DISTINCT
ID,
[2nd_Dim] AS [2nd_Dim ANDMode]
RESIDENT Fact;
-------------------------------------------------
EvanKurowski Jul 24, 2013 7:32 AM (in response to toucangulyayu)
Thank you Toucan, you are correct.
You know I think what made this so frustrating was that I tried Gysbert's suggestion where I was loading tables with repeating Organization entries, and I kept getting this reload error message that said something like "the values in the ID table must be unique". I don't know how it worked for him, but yesterday that was definitely not allowed.
Going over it again this morning, I can't seem to duplicate that error message, and any combination of repeating values from any table in the data model seem to work. Anyone know what creates that 'unique condition required' error condition with regards to ANDMode construction?
Helpful Answer
------------------------------------------------------------
Vishwaranjan Kumar Jul 24, 2013 7:15 AM (in response to EvanKurowski)
SEE ATTACHED FILE
