Strange Behavior - On Selection

[aveeeeeee7en]

Hi All

I am facing some strange behavior on Selection. See the Snapshot:

Regards

Aviral Nag

[MK_QSL]

Provide your sample file... need to see the association between Month and Year...

If you want to check, create a table box with only two dimensions... Year and Month... and analyse it.

[manojkulkarni]

It looks like some event is getting triggered on selection of Month. Please check.

[ashfaq_haseeb]

Hi,

I thing you extract Yea Month in front end..

Calculate them in back-end.

If possible share a sample for further analysis.

Regards

ASHFAQ

[Colin-Albert]

Can you show the fields / expressions from the Year & Month list boxes, and how these fields are related in your data model.

A screen-shot of the Current Selections window may also help show exactly what data is being selected.

[sujeetsingh]

Check data model and values present

[qlikoqlik]

HI Aviral

When you select Aug it will highlight all the relevant years associated with the month Aug

Thanks and regards

Padma

[aveeeeeee7en]

Thank You All for the replies.

I have a list box which is in Number Format. See the Snapshot:

I am converting these Month Numbers to Month Names using 2 Expressions:

1) dual(left(monthname(makedate(YEAR,MONTH)),3),MONTH)

When I am using this expression in List Box Expression  than I am facing this problem:

2) IF(MONTH=1,dual('Jan',1),
    IF(MONTH=2,dual('Feb',2),
    IF(MONTH=3,dual('Mar',3),
    IF(MONTH=4,dual('Apr',4),
    IF(MONTH=5,dual('May',5),
    IF(MONTH=6,dual('Jun',6),
    IF(MONTH=7,dual('Jul',7),
    IF(MONTH=8,dual('Aug',8),
    IF(MONTH=9,dual('Sep',9),
    IF(MONTH=10,dual('Oct',10),
    IF(MONTH=11,dual('Nov',11),
    IF(MONTH=12,dual('Dec',12)))))))))))))

When I am using this expression in List Box Expression  than I am facing no Problem:

Why????? I am facing problem with expression:

dual(left(monthname(makedate(YEAR,MONTH)),3),MONTH)

Regards

Aviral Nag

[ashfaq_haseeb]

Hi,

As I say you are extracting month in front end.

That is why you have this issue.

try by extracting month in your script.

I'm sure you will not have this issue after that..

Regards

ASHFAQ

[Colin-Albert]

If you generate the Month & Year values in your load script from your date fields, you will have the correct relationship between the date, month and year and the selections will work correctly.

e.g.

Load

     date(trans_date) as trans_date,

     month(trans_date) as trans_mth,

     year(trans_date) as trans_yr,

     ...

from ...... ;