Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dimension label for class

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.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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

View solution in original post

24 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try using this

          Num(Class(AngleTabPos,10)) + 10

Hope it helps

Celambarasan

Not applicable
Author

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Celambarasan

Not applicable
Author

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.

x-axis.JPG

Thanks

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Celambarasan

Not applicable
Author

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Not applicable
Author

Yes, exactly same like that.

Thanks

CELAMBARASAN
Partner - Champion
Partner - Champion

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