topic Re: Strange Behavior - On Selection in QlikView

Strange Behavior - On Selection

aveeeeeee7en — Wed, 27 Aug 2014 09:25:07 GMT

Hi All

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

Regards

Aviral Nag

Re: Strange Behavior - On Selection

MK_QSL — Wed, 27 Aug 2014 09:27:42 GMT

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.

Re: Strange Behavior - On Selection

manojkulkarni — Wed, 27 Aug 2014 09:36:15 GMT

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

Re: Strange Behavior - On Selection

ashfaq_haseeb — Wed, 27 Aug 2014 09:43:08 GMT

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

Re: Strange Behavior - On Selection

Colin-Albert — Wed, 27 Aug 2014 09:45:59 GMT

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.

Re: Strange Behavior - On Selection

sujeetsingh — Wed, 27 Aug 2014 09:48:55 GMT

Check data model and values present

Re: Strange Behavior - On Selection

qlikoqlik — Wed, 27 Aug 2014 10:32:13 GMT

HI Aviral

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

Thanks and regards

Padma

Re: Strange Behavior - On Selection

aveeeeeee7en — Thu, 28 Aug 2014 10:48:07 GMT

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

Re: Strange Behavior - On Selection

ashfaq_haseeb — Thu, 28 Aug 2014 10:50:52 GMT

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

Re: Strange Behavior - On Selection

Colin-Albert — Thu, 28 Aug 2014 13:14:34 GMT

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