Quarter

[soha1902]

Hi All,

I have 2 fields in my dashboard FiscalYear and FiscalQuarterID. I used Right(FiscalQuarterID,2) expression and created one QTR field in UI. When I select a Year from FiscalYear and a Field in newly created QTR field it will not turn Green(as per qlikview default selection) and also in current selection it is showing multiple FiscalQuarterID.See below screenshot:

Can any one please help me to solve this?

Thanks in advance.

[#2]

Can you reduce your qv app size. I am not able to download

[Chanty4u]

yes it gives u exctly

right( s , n )

Substring of the string s. The result is a string consisting of the last n characters of s.

Example:

right('abcdef',3 ) returns 'def'.

[nishanthi_8]

Yes it will show multiple selections in the current selection box since Q2 is related to these years also that is 2013,2014,2015 and 2016. but i couldn't understand your selection clarification that is:

When I select a Year from FiscalYear and a Field in newly created QTR field it will not turn Green(as per qlikview default selection)

Can you be more clear?

[jagan]

Hi,

It is correct, since you are deriving the QTR from FiscalQuarterId Right(FiscalQuarterId, 2).  When you select Q2 it satisfies for all the Q2 quarters.  The best thing is implement this in script instead of front end to avoid this type of issues.

LOAD

*,

Right(FiscalQuarterId, 2) AS QTR

FROM DataSource;

Also calculated fields have performance issues, so better move this into script.

Hope this helps you.

Regards,

Jagan.

[Chanty4u]

chk sample

[Chanty4u]

sry

[Digvijay_Singh]

I think this situation happens when QTR field is selected after selecting Year. I could also see this behaviour as shown in this image -

jagan‌ it looks logical as you said when QTR field is hit first, but this situation can be seen when year is clicked first and then QTR list box value is clicked. I think when QTR field is clicked it contradicts the previous selection and that can be seen when QTR value is not turning into green background.

But Current selection behaviour is weird, when selection has not happened then why it is showing other quarters. May be Jagan can answer that if I could represent this situation properly.

[Digvijay_Singh]

One more thing I realised, When QTR or Q3( in my image)  list box value is clicked, the only possible quarter of already selected year(2016Q3 in image I shared) turns green to respect our existing selections. This behaviour appears logical but current selection box should not show other quarters except 2016Q3( in the image I shared)

[jagan]

I think it is correct, since it is calculated dimension.  You wont face this type of issues when you derive this in script.

Regards,

Jagan.