need hlp

[qlikapple]

Hi

ineed o set a  bar graph keeping lower and uperlimits  how?

[simospa]

Hi Sahaja,

what do you mean?

Do you want to set a static minimum / maximum? If you need this, under Properties --> Axes --> Check Static Min / Static Max and insert a fixed value or a formula.

But please explain better your request.

Thank you.

S.

[qlikapple]

hi i have dimension in straighttable as group name and in the expression as

count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}ID) ,

i want to show in the bar chart  with x axes  as month and in the y axes as  as expreesion based on the group name,

how the user will select  based on the group name ,

and alos i need to set limits

upper linit as 2 and lower limit as 5

how to keep the limits, i came to know by refrence lines

but how to do with dynamic refrence lines

[poojashribanger]

on what condition you want to set limits?

[qlikapple]

on the  expression condition i want o set the limits

can anyone please help, i need to set the dynamic limits

[vishsaggi]

Can you share some sample data and your expected output like where exactly you want to set those limits? When you say dynamic limits does the limits need to be changed i mean are 2 and 5 Limits static or it changes? Or are you looking for ref line to show and hide in bar graph? IF you can elaborate a little with some sample data it will be easy for everyone to give a quick solution.

[poojashribanger]

to set dynamic limit u need to have some criteria