Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kkkumar82
Specialist III
Specialist III

Can we have sliders taking alphanumeric and text values

Hello All,

I have a situation where I have a list box named Quarter year, by the name you can except the values it can have like

Q1'12,Q2'12........., Q1'16.

Now I want to have a slider for this field where I want to select two Quarters and I want to run the analytics.

The problem I have is when go for the properties and select "field" in the slider nothing is shown on the slider and even the slider got struck.

As of now I maintaining it with numeric values for the thing to work, but is there a chance to make it work, the slider

or any other suggestion is suggestible.

Regards

KK

10 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In your calendar LOAD statement, next to QuarterYear, add a field with a name like QuarterYearNum that contains Year()*10+QuarterNum, leading to values of 20141 for Q1'14 etc.

A field like that can be used in a slider.

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or even better, use the dual() function on top of my previous solution.

When creating QuarterYear, make sure that you have both a string value (e.g. Q1'12, Q2'12, ...) and a numerical value (e.g. corresponding with the previous = 20121, 20122, 20123 etc.)

In your LOAD statement, create the QuarterYear field as follows:

:

dual(StringVersionOfQuarterYear, NumericalVersionOFQuarterYear) AS QuarterYear,

:

Replace both placeholders in italics with the expressions that calculate the corresponding values.

That one can be used in a slider as well, as shown below:

StringsInSliders.jpg

Best,

PEter

kkkumar82
Specialist III
Specialist III
Author

Hi Peter,

I will try and get let you know the solution.

Thank You

kkkumar82
Specialist III
Specialist III
Author

Hi peter,

I have tried your solution , but I am not successful.This is my script.

FiscalCalendar:

load *,

       dual(QuarterYear,Year * 10 +QuarterNo) as QuYr;

Load *,

       right(Quarter,1) as QuarterNo;

Load *,

  Year(FiscalDate) as Year,

  'Q'&ceil(month(FiscalDate) / 3) as Quarter,

    'Q'&ceil(month(FiscalDate)/3) & chr(39) &  Right(Year(FiscalDate), 2) as QuarterYear,

    'FY'&Right(Year(FiscalDate),2)&'P'& Num(Month(FiscalDate)) as Month,

    //Date(MonthStart(TempDate), 'MMM-YYYY') As MonthYear,

    //Week(FiscalDate) as Week,

    //WeekDay(FiscalDate) as WeekDay,

    //Week(TempDate) & '-' &Year(TempDate) as WeekYear,

    Day(FiscalDate) as Day,   

    InYearToDate(FiscalDate, $(vToday), 0) * -1 as CurYTDFlag,

    InYearToDate(FiscalDate, $(vToday), -1) * -1 as LastYTDFlag,   

    Year(YearStart(FiscalDate, 0, 4)) as FiscalYear;

Load

  TempDate as ForecastDate,

  AddMonths(TempDate,$(vMonthCount)) as FiscalDate

Resident TempCal Order by TempDate asc;

DROP TABLE TempCal;

And I have used QuYr for slider, but my slider is showing the numeric values rather than the string representation.

Any suggestions??

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Weird. It does work for me, although the dual() function indeed makes the field act like a numerical value.

StringsInSliders2.jpg

What happens if you select QuarterYear as slider field? Never mind the sorting order.

Peter

kkkumar82
Specialist III
Specialist III
Author

Hi peter,

The slider is showing alphanumeric for single value or multiple value mode but when I select continuous /numeric

value mode it is showing the numeric values like 20101, 20102....

In my application I want to show the forecast ...   for the end user between any two quarters like Q114 -  Q315.

I think you have go to it.

I will try to post a qvw, just give me some time.

Anonymous
Not applicable

i m having a query can u c it once kiran

kkkumar82
Specialist III
Specialist III
Author

Hi peter,

I checked ur sample thank you for providing it.

According to ur sample if we multi select I dont wont the range of values , I want the first and last Quarters.

New Picture.bmp

In the above I want Q4'14 and Q2'15 but when I go for continuous value mode all string representation is converted into numberic.

If we take variables in the slider other than QuYR can we change achieve, i tried but what the "Step"should be.

kkkumar82
Specialist III
Specialist III
Author

Hi,

I didn't get you.