Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

display the common value based on active and comparison selection

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).

Capture1.JPG.jpg mel.JPG.jpg

Thank you in advance.

4 Replies
Not applicable

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

Use the following Exp.


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

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

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.

MVP
MVP

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

HI,

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

Regards,

Jagan.

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

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.

Capture.JPG.jpg

Community Browser