Discussion Board for collaboration on QlikView Layout & Visualizations.
I have the selection field like the above.
Act. YearMonth = Active Year Month
Comparision Year Month = Assigned to one variable (vComparision_selection).
Mel(Key) or Mel - Display value (List box).
I need the expression in the list box to display the Mel(Key) which is active in both the Active and comparison (Like intersection).
Thank you in advance.
Use the following Exp.
I have variable for comparison part only(vcomparisonselection) not for active year month.
and MEL is the string. Just i need to display the common MEL in active year month and comparison yearmonth.
hope, this would be clear.
Can you attach some sample data, it helps in understanding the data and easy to give solution.
find the attachment. In the attached file, MEL value is available in different Year Month field.
I need the MEL which is common in based on the below selection.
in the below example, if the MEL is there in Act.YearMonth(201308) and comparison YearMonth(201208), it will display based on the expression.
comparion YearMonth variable - vComparisonSelection.