topic Re: display the common value based on active and comparison selection in QlikView

display the common value based on active and comparison selection

settu_periasamy — Mon, 07 Oct 2013 10:24:41 GMT

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.

Mon, 07 Oct 2013 10:35:11 GMT

Use the following Exp.

SUM({$<ComparisonYearMonth=P(Act.YearMonth),Act.YearMonth=>} MEL)

settu_periasamy — Tue, 08 Oct 2013 02:36:16 GMT

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.

jagan — Tue, 08 Oct 2013 04:06:05 GMT

HI,

Can you attach some sample data, it helps in understanding the data and easy to give solution.

Regards,

Jagan.

settu_periasamy — Tue, 08 Oct 2013 04:49:05 GMT

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.