topic Re: conditional text on axis in QlikView

conditional text on axis

lockematthewp — Fri, 26 Jul 2019 14:41:30 GMT

I currently have a bar chart showing actual hours vs forecasted hours. these are split by project numbers. I want to show the project descriptions on the x axis. I am able to do so but it shows for both the actual and the forecast bar for each project. how can I only show the description on the larger of the two bars? I cant figure out how to compare the expressions. I would really appreciate any help.

Re: conditional text on axis

Anil_Babu_Samineni — Fri, 26 Jul 2019 15:00:08 GMT

Try to share sample application to help

Re: conditional text on axis

lockematthewp — Fri, 26 Jul 2019 15:16:46 GMT

This is for work so I am unable to share the actual file. but I made a similar one as an example. I would only like to show the project description on the larger of the two bars. as of now I show it only on the forecast bar, but some projects have no forecast value so no description is shown.

Re: conditional text on axis

Brett_Bleess — Tue, 20 Aug 2019 14:47:42 GMT

Matthew, The only way I see to potentially do it is to have the Desc field be null for the Forecast, but I am not sure how to do the data model to accomplish that and still have things properly linked. The problem is with everything in single table, the Desc applies to all rows etc. If you could split the Actual and Forecast into two separate tables where in the Forecast table the Desc is null, I think that would get you what you want here, and as far as I can see, that is the only way to go at things, but I am not a development guru, so hopefully someone else may now see this and think of another way to go at it, but I wanted to toss this out just in case you may be able to make it work.

Regards,
Brett

Re: conditional text on axis

lockematthewp — Tue, 27 Aug 2019 14:00:31 GMT

I managed to solve this by just concatenating the description to the Project No. with a space in between.

=[Proj No(B)] & chr(10) & [Project Des(B)]