Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
This works fine if I want them in one cell but I wan't them to be in separate cell's.
Then you will have to drop the Concat() and let your dimension(s) create the necessary rows for you...
Why don't you just add the dimension Registered_CCG ?
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.
Not sure what you mean, but you can always make the Dimension conditional depending on the user selections
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
Like said you can show these dimensions conditionally based on the user slections
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.