topic Re: dimension label for class in QlikView

dimension label for class

Mon, 30 Jan 2012 08:31:08 GMT

Hi,

In attached qvw file contains a barchart.

In dimesion tab:

Class(AngleTabPos,10)

In expression tab:

Count(Lenskey)

Note :User has a chance to view only 10 values(bars) at a time.

Now what i am trying to work is in dimension labels are displaying as "0<=x<10, 10<=x<20, 20<=x<30..................350<=x<360", but what i want to display is "10,20,30,...............360".

Is it possible to do this ?

Thanks in advance.

dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 08:45:47 GMT

Hi,

Try using this

Num(Class(AngleTabPos,10)) + 10

Hope it helps

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 09:05:17 GMT

Hi,

Its working for angletabpos, but for lenskey field it is not working as expected.

For newly attached qvw file contians dimension :

Class(Lenskey,100)

it is displaying like "1879586700<=x<1879586800, 1879586800<=x<1879586900, ........."

i tried using your funcitonality i.e;

Num(Class(LensKey,100)) + 100

it is displaying like "1879586800, 1879586900,................"

But it should the values is count difference ; like "100, 200, 300, ..............."

please can you check this .

Thanks in advance.

dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 09:20:29 GMT

Hi,

I'm using personal edition i cann't open your file.Please give image description of your problem.

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 10:00:52 GMT

Hi,

i tried using your funcitonality i.e;

Num(Class(LensKey,100)) + 100

it is displaying like " 1879586700, 1879586800, 1879586900,................"

But it should the values is count difference ; like "100, 200, 300, ..............."

please see the below image how it shows in linechart.

Thanks

Re: dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 10:22:42 GMT

Hi,

Sorry i couldn't get your problem little bit clear please..

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 11:01:08 GMT

Hi,

In LineChart, below to the horizontal scroll, the values displayed like below

" 1879586700, 1879586800, 1879586900,................"

The values displayed in linechart are getting from its min of field and adding 100 to it,

but it should show range difference like 100, 200, 300,....

I hope now you understand the concept what i am trying !

Thanks.

dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 11:42:17 GMT

Hi,

Instead of 1879586700 u need to display 100 and for 1879586800 is 200 and so on like this?

Re: dimension label for class

Mon, 30 Jan 2012 11:46:18 GMT

Yes, exactly same like that.

Thanks

Re: dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 12:05:46 GMT

Hi,

Then have a variable like vRange with value "=(Min(Lenskey)-100)"

Use dimension expression like this Num(Class(LensKey,100)) - vRange

Hope it helps

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 12:18:48 GMT

Hi,

No its not getting what we expected. It is showing like "3739, 3939, 4339..." instead of "100,200,300,...".

I done same what you mentioned in post , but not able to get it.

Any other way to get it.

Thanks

Re: dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 12:23:16 GMT

Can you check and tel me whats min(Lenskey) there?

Re: dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 12:28:52 GMT

Hi,

Can you attach a image as chart with vRange(Num(Class(LensKey,100)) - vRange) variable and without vRange(Num(Class(LensKey,100)) ) variable , vRange value and Min(LensKey) value in text object.

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 12:29:41 GMT

Hi,

Min of Lenskey =1879586761

Thanks

Re: dimension label for class

Mon, 30 Jan 2012 12:42:55 GMT

Hi,

Please find the attached images of "WithvRange" , "WithOutvRange", "vRange", "Min(Lenskey)" values.

Thanks

Re: dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 12:45:24 GMT

Hi,

Check with this

vRange with value "=((floor(Min({1}Lenskey)/100)*100)-100)"

Use dimension expression like this Num(Class(LensKey,100)) - vRange

Hope it helps

Celambarasan

Re: dimension label for class

Mon, 30 Jan 2012 13:07:03 GMT

Hi,

No, it is displaying like 3800, 4000, 4400, 4700...........

Thanks

dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 13:14:52 GMT

Hi,

Have you done any selection or ignored selection in your expression?

Re: dimension label for class

Mon, 30 Jan 2012 13:20:47 GMT

Hi,

i used single expression as seen below :

=Count({$<DefectName={"Defect.EdgeChip"}>} LensKey)/Count({$<DefectName={"Defect.EdgeChip"}>} TOTAL LensKey)

Thanks

dimension label for class

CELAMBARASAN — Mon, 30 Jan 2012 13:27:31 GMT

Hi,

Then add that set analysis expr to the min

vRange with value "=((floor(Min({$<DefectName={'Defect.EdgeChip'}>} Lenskey)/100)*100)-100)"

Use dimension expression like this Num(Class(LensKey,100)) - vRange

Hope it helps

Celambarasa