Quarter Year display in chart Lable

[Anonymous]

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

[sorrakis01]

Hi,

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

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

Regards

[Anonymous]

i want this in chart lable based on user selections

Thanks

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[arulsettu]

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

use this quarter in chart

[sorrakis01]

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

[Anonymous]

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

[Anonymous]

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

[alex_millan]

Hi,

In title text:

=Subfield(YourFieldName,' ',1)

HTH

Regards

[sorrakis01]

Hi, Use Alex expression.

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

Next time reload the project.

Regards