topic Re: URL not displayed when multiple rows in QlikView

URL not displayed when multiple rows

Anonymous — Sat, 07 Nov 2015 00:12:58 GMT

I am trying to display a URL in a stairght table here is my expression a&<'url'>&b but for few rows its actually displaying a blank(where are 2 records for same person/date) , as soon as I include dimensions a and b in the chart all the url values displays correct..

Can someone please let me know why is this caused ? and how do I include those 2 dimensions in expression rather than dimensions .. for now I have included them in dimensions and hidden.

Thanks!

Re: URL not displayed when multiple rows

sunny_talwar — Sat, 07 Nov 2015 00:16:13 GMT

As you mentioned it yourself that when there are 2 records, Straight Table doesn't know which value to display. You need to tell it which one it needs to display: First Value or Last Value or Both Values in the same column?

Re: URL not displayed when multiple rows

Anonymous — Sat, 07 Nov 2015 00:28:48 GMT

How do I display both ?

Re: URL not displayed when multiple rows

sunny_talwar — Sat, 07 Nov 2015 00:33:58 GMT

You can use Concat()

Concat(a) & <'url'> & Concat(b)

Re: URL not displayed when multiple rows

Anonymous — Sat, 07 Nov 2015 00:35:19 GMT

actually I want to display in 2 rows not in a single row

Re: URL not displayed when multiple rows

sunny_talwar — Sat, 07 Nov 2015 00:38:14 GMT

‌I guess in that case add a and b as your dimension and then hide both these using hide column check box on presentation tab of straight table's properties.

Re: URL not displayed when multiple rows

Anonymous — Sat, 07 Nov 2015 00:39:07 GMT

That's what I am doing now .. but I don't want to include in dimension , can I someway add in the expression itself ?

Re: URL not displayed when multiple rows

sunny_talwar — Sat, 07 Nov 2015 00:42:10 GMT

I doubt it would be possible without adding the dimension. But what is the issue with adding the dimension? You won't see a and b dimension as they are going to be hidden.