topic Re: need hlp in QlikView

need hlp

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: need hlp

simospa — Tue, 28 Aug 2018 12:50:01 GMT

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.

Re: need hlp

qlikapple — Tue, 28 Aug 2018 13:12:25 GMT

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

Re: need hlp

poojashribanger — Tue, 28 Aug 2018 13:37:01 GMT

on what condition you want to set limits?

Re: need hlp

qlikapple — Tue, 28 Aug 2018 14:03:44 GMT

on the expression condition i want o set the limits

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

Re: need hlp

vishsaggi — Tue, 28 Aug 2018 14:14:54 GMT

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.

Re: need hlp

poojashribanger — Thu, 30 Aug 2018 12:46:24 GMT

to set dynamic limit u need to have some criteria