Discussion Board for collaboration related to QlikView App Development.
I have as an example the following table and fields:
and independent fields:
Enduser selects from each Field (System A, B and C) a value. As an example hier: A1,B1 and C1.Desired output:
Field Systems from Table_a should based on the previous selections show only A1,B1 and C1 and there the enduser can select a value between A1, B1 and C1 from the same field.
Any help please?Thanks in advance.
I would recommend creating 3 inline tables, one for each of the System A, B, C
load* inline [SystemAA1A2A3];
Then, in the dimensions field, you can create a calculated dimension like this:
This will result in nothing showing if there are no selections for System A, System B, or System C. You can create a Document Settings/Trigger such that if nothing is selected, all of them get selected for the the System selections.
Thanks @OceanView for your reply.
I don't want to create a new dimension field. I want only to make changes on existing field, from which other fields from the same table are depending.
Changes: Based on previous selections, the already existing field should 'ban' the remaining non selected values.
I want to preserve the field Systems and not to create a new one, because based on it I have other calculations to perform.
I hope that you understand my issue and to help me further!Thanks in advance.
Check the attached qvw.
@krishna_2644 Thanks for your reply.
The idea linking tables with creating a commun key is good, but it has a problem that by choosing A1, you're imposing choosing B1 and C1 (because you setted for A1, B1 and C1 the key value=1).
Any help please?
Thanks in advance.