topic Re: Quarter in QlikView

Quarter

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Quarter

Wed, 23 Mar 2016 06:46:43 GMT

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

Re: Quarter

Chanty4u — Wed, 23 Mar 2016 06:49:45 GMT

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

Re: Quarter

nishanthi_8 — Wed, 23 Mar 2016 06:51:21 GMT

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?

Re: Quarter

jagan — Wed, 23 Mar 2016 06:51:21 GMT

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.

Re: Quarter

Chanty4u — Wed, 23 Mar 2016 07:00:11 GMT

chk sample

Re: Quarter

Chanty4u — Wed, 23 Mar 2016 07:00:43 GMT

sry

Re: Quarter

Digvijay_Singh — Wed, 23 Mar 2016 07:09:54 GMT

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.

Re: Quarter

Digvijay_Singh — Wed, 23 Mar 2016 07:15:20 GMT

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)

Re: Quarter

jagan — Wed, 23 Mar 2016 07:27:09 GMT

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.

Re: Quarter

tyagishaila — Wed, 23 Mar 2016 07:32:56 GMT

create QTR field in script.

Re: Quarter

jonathandienst — Wed, 23 Mar 2016 07:34:23 GMT

A selection on a list box expression actually makes a selection on the underlying physical fields.