Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
Champion III
Champion III

Re: multibox date field is showing duplicate records

hi

PFA,

Highlighted
MVP & Luminary
MVP & Luminary

Re: multibox date field is showing duplicate records

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

Highlighted
Contributor
Contributor

Re: multibox date field is showing duplicate records

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

Highlighted
Creator III
Creator III

Re: multibox date field is showing duplicate records

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

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