Straight Table

[#1]

Hi all bit of a Thursday teaser currently working through a change request for my client and I have come up with an idea I just need to try and write it. My current code " =IF(COUNT(DISTINCT(Registered_CCG_Code))>=1,CONCAT(DISTINCT(Registered_CCG),Chr(13),0)) " works great in a text box but what I want to do is show a new line for each in a straight table. After Chr(13), there will be a new if statement. Any help would be great.

[nagaiank]

In the Properties window, Presentation tab, check 'Wrap Cell Text' check box and increase the Cell Height to the maximum number of distinct Registerd_CCG_Code.

[#3]

This works fine if I want them in one cell but I wan't them to be in separate cell's.

[petter]

Then you will have to drop the Concat() and let your dimension(s) create the necessary rows for you...

[stigchel]

Why don't you just add the dimension Registered_CCG ?

[#6]

The reason I don't want to just add Registered_CCG is because this will eventually go into a multi parameter graph so No mater if the end user chooses Registered_CCG or Postcode it will give them either or both. My main aim will be to create 1 graph that the axis will change according to what the end user has chosen.

[stigchel]

Not sure what you mean, but you can always make the Dimension conditional depending on the user selections

[#8]

Best way to explain it one graph multiple options for an axis. Maybe the count should not be the way to go.

Example I have at current 8 separate graphs for each of the parameters but if I can do 1 graph and the axis is either 1 or all 8 parameters this would save my Qlikview a lot of space

[stigchel]

Like said you can show these dimensions conditionally based on the user slections

[#10]

I have tried this already, but does not give me what I wan't. I will leave it for now and revisit it in a couple of weeks.