topic Re: Straight Table in QlikView

Straight Table

Thu, 07 May 2015 13:42:35 GMT

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.

Re: Straight Table

nagaiank — Thu, 07 May 2015 13:54:26 GMT

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.

Re: Straight Table

Thu, 07 May 2015 14:20:12 GMT

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

Re: Straight Table

petter — Thu, 07 May 2015 14:27:32 GMT

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

Re: Straight Table

stigchel — Thu, 07 May 2015 14:33:47 GMT

Why don't you just add the dimension Registered_CCG ?

Re: Straight Table

Thu, 07 May 2015 14:38:19 GMT

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.

Re: Straight Table

stigchel — Thu, 07 May 2015 14:42:43 GMT

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

Re: Straight Table

Thu, 07 May 2015 14:47:38 GMT

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

Re: Straight Table

stigchel — Thu, 07 May 2015 14:59:57 GMT

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

Re: Straight Table

Thu, 07 May 2015 15:10:04 GMT

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.