Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Range of Quarter

Hi Guys..I have field Quarter which has quarter value as 3Q14, 4Q14 like that, How can i select range of quarter selected.

For example i want to select quarter range from 3Q13 to 2Q14. I tried with input box but its not working ,its working only for date.

Please help me

1 Solution

Accepted Solutions
tresesco
MVP
MVP

As I said it would be a workaround (because the best option is to create quarter using QuarterName() function to get proper date representation that allows comparison unlike this text.).

PFA for alternate solution.

View solution in original post

8 Replies
tresesco
MVP
MVP

Possibly, it is not working because your quarter dimension is merely a text representation and not a proper date. Still there would be work around, could you please post a sample?

Anonymous
Not applicable
Author

Example i have Target_Quarter and Sales field.

Target_Quarter    Sales

    1Q12                10

    2Q12                20

    3Q12                30

    4Q12                10

    1Q13                18

    2Q13                17

    3Q13                20

    4Q13                21

    1Q14                25

    2Q14                10

    3Q14                16

    4Q14                17

its just a small example, if suppose i want to see sales of only 2Q12 to 1Q14??only that range should be selected.How can i achieve this.

Not applicable
Author

Hi,

I don't understand your question. What is the problem in selecting the range of values from a Qtr list box?

do you have any issues in sorting order? or you want to handle it in expression? can you pls elaborate your requirement

Anonymous
Not applicable
Author

Hi Gowri, this is small example that has very less data, here i can select quarter from list box itself but in my application many quarters are there, How could I select with input box so that if i enter start quarter and end quarter, all the quarter in that range will be selected.

sujeetsingh
Master III
Master III

Split it in the script only .

Not applicable
Author

Hi,

Your problem will be solved if you fromat the value as below

12Q1

12Q2

12Q3

12Q4

13Q1

13Q2

Let say if you are particular about your exisiting format, then you may have to use some logical island for selection as a work around

tresesco
MVP
MVP

As I said it would be a workaround (because the best option is to create quarter using QuarterName() function to get proper date representation that allows comparison unlike this text.).

PFA for alternate solution.

Anonymous
Not applicable
Author

Hi tresesco thanx a lot..It worked for me and this is what i wanted. thanx again