topic Re: Quarter Year display in chart Lable in QlikView

Quarter Year display in chart Lable

Anonymous — Wed, 29 Apr 2015 11:34:55 GMT

hi gurus,

if i select "Quarter year" it should display Q1,Q2,Q3,Q4 in chart lable

Source: Q1 14, Q2 14, Q3 14,Q4 14

output: Q1,Q2,Q3,Q4...........

multiple selection display

using Get field selections

Thanks

Re: Quarter Year display in chart Lable

sorrakis01 — Wed, 29 Apr 2015 11:40:40 GMT

Hi,

If you use Masrter Calendar in script, you can create this:

'Q' & Ceil(Month(TempDate)/3) AS [Quarter Year],

Regards

Re: Quarter Year display in chart Lable

Anonymous — Wed, 29 Apr 2015 11:41:48 GMT

i want this in chart lable based on user selections

Thanks

Re: Quarter Year display in chart Lable

Gysbert_Wassenaar — Wed, 29 Apr 2015 11:42:43 GMT

Please read these two documents:

Re: Quarter Year display in chart Lable

arulsettu — Wed, 29 Apr 2015 11:43:23 GMT

'Q'& ceil(month(datefield)/3) as quarter

use this quarter in chart

Re: Quarter Year display in chart Lable

sorrakis01 — Wed, 29 Apr 2015 11:45:20 GMT

Use [Quarter Year] on Dimension.

But your question is not very clear. If you can explain better your problem and upload the project if is necessary

Regards

Re: Quarter Year display in chart Lable

Anonymous — Wed, 29 Apr 2015 11:50:38 GMT

Hi Babu,

As I am not much clear about your requirement, I have shared based on my understanding

Load

'Q'&' '& Year_Field

QTR_Field

From Table_Name;

So if you select any of year you will get corresponding Q Values.

-Jay

Re: Quarter Year display in chart Lable

Anonymous — Wed, 29 Apr 2015 12:02:06 GMT

Hi Gysbert thanks for your advice.

i want to display in chart window title like Q1,Q2,Q3,Q4 as per user selection

Actual Field like :Q1 14,Q2 14.,Q3 14,Q4 14...

Out put required :Q1,Q2,Q3,Q4

need to remove '14' after user selection

please find the sample application

Thanks

Re: Quarter Year display in chart Lable

alex_millan — Wed, 29 Apr 2015 12:04:22 GMT

Hi,

In title text:

=Subfield(YourFieldName,' ',1)

HTH

Regards

Re: Quarter Year display in chart Lable

sorrakis01 — Wed, 29 Apr 2015 12:07:40 GMT

Hi, Use Alex expression.

or in label you can use Mid(Quarter,1,2) regards

Next time reload the project.

Regards

Re: Quarter Year display in chart Lable

CELAMBARASAN — Wed, 29 Apr 2015 12:13:23 GMT

Try in chart title

=Concat(Left([Quarter Year], 2), ', ')

Thanks

Re: Quarter Year display in chart Lable

Anonymous — Wed, 29 Apr 2015 12:17:16 GMT

Hi Alex,

Hi Thanks for your Time subfield with getfield selections not displaying multiple selections in chart window

Re: Quarter Year display in chart Lable

alex_millan — Wed, 29 Apr 2015 12:20:53 GMT

Hi again,

If you don't need the second part of your values ( ' 14'), why don't you simply dismiss it on the script?

Use the same command on the script when loading the values, for example:

LOAD Subfield([Quart yer],' ',1) As [Quart yer], Sales;

LOAD [Quart yer], Sales FROM [Quarter year.xlsx](ooxml, embedded labels, table is Sheet1);

Perhaps that simplifies the problem.

Good luck 😉