Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy

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

Use the following Exp.


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

settu_periasamy
Author

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
MVP
MVP

HI,

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

Regards,

Jagan.

settu_periasamy
Author

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