Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multibox date field is showing duplicate records

Hi ,

In my multibox date field record having showing same values multiple times.

can you help to see only one value for one mon-yyyy.

please find the sample qvw for reference.

Thanks,

Q Kumar

4 Replies
Chanty4u
MVP
MVP

hi

PFA,

marcus_sommer

You need to take a real YearMonth field and not formatting a date-field which then has of course several different values for thi s format. Recommended is for tis to use a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

Anonymous
Not applicable
Author

Suresh,

i want to see unique MMM-YYYY values in the field of multibox, but not the entire dates.

in some approaches i am getting Duplicate MMM-YYYY values like:

JAN-2015

JAN-2015

FEB-2015

But i wanna result like below:

DEC-2014

JAN-2015

FEB-2015

Tahnks,

Ravi

roger_stone
Creator III
Creator III

You could use an expression in the multiBox and label it DateRec, with the expression:

=MONTH(DateRec) & '-' & YEAR(DateRec)