topic Re: Treat .1 & .10 differently in QlikView

Treat .1 & .10 differently

amars — Mon, 22 May 2017 07:19:55 GMT

Hi all ,

I have a strange problem. I am creating a dashboard for some survey.

Now the survey has Question & SubQuestion.

So for example

Question SubQuestion

1 1

1 2

1 10

1 11

I wish to represent the Question Number as 1.1, 1.2, 1.3, 1.10 format but when I concatenate Question & Sub Question it interprets it as numbers and shows both "1.1" & "1.10" as 1.1. Using Text or any function is of no user. Can anyone suggest what should I do?

Thanks in advance.

Amar

Re: Treat .1 & .10 differently

goro2010 — Mon, 22 May 2017 07:24:47 GMT

Good Day,

On you load use a combine function.

Example:

Question & '-' & SubQuestion as TotalQuestion

Thank You

Re: Treat .1 & .10 differently

tresB — Mon, 22 May 2017 07:26:39 GMT

This?

Load *,

Text(Question&'.'&SubQuestion) as New

Re: Treat .1 & .10 differently

amars — Mon, 22 May 2017 07:26:49 GMT

Thanks for the reply Jan,

I know that changing the separator will solve the issue.

When displaying the data values I wish to show them as Index and thus want to use "." & not "_".

Any other suggestions?

Re: Treat .1 & .10 differently

vinieme12 — Mon, 22 May 2017 07:28:00 GMT

you already have the answer to your question

load text(Question&'.'&SubQuestion) as Combined inline [

Question,SubQuestion

1,1

1,2

1,10

1,11

];

Re: Treat .1 & .10 differently

goro2010 — Mon, 22 May 2017 07:28:28 GMT

Try below as suggested by Tresesco.

Re: Treat .1 & .10 differently

avinashelite — Mon, 22 May 2017 07:34:11 GMT

You need to convert your SubQuestion to text in the script level then you could resolve this

LOAD * ,

Text(SubQuestion) as New_SubQuestion

from

then combine the two fields ..this will solve your problem

Re: Treat .1 & .10 differently

antoniotiman — Mon, 22 May 2017 07:34:25 GMT

Hi Michael,

I don't notice this issue

LOAD *,Question&'.'&SubQuestion as A Inline [
Question SubQuestion
1 1
1 2
1 10
1 11
](delimiter IS SPACES);

However try

Question&'.'&Text(SubQuestion) as Field

Regards,

Antonio

Re: Treat .1 & .10 differently

amars — Mon, 22 May 2017 07:35:53 GMT

Thanks a lot Tresesco. Will try this one

Re: Treat .1 & .10 differently

Kushal_Chawda — Mon, 22 May 2017 07:36:35 GMT

this should work

text(Question&'.'&SubQuestion) as QuestionNew