topic Re: dynamic report dimension in QlikView

dynamic report dimension

alexpanjhc — Mon, 17 Sep 2012 14:54:25 GMT

I am creating a dynamic report.

Everything looks fine except that when I have 2 similar columns , they show together even i only choose the longer name one.

For example, in my inline load

dimension:

LOAD *

INLINE

[

_dimension, dimension_type

Customer, Customer

CustomerID, Customer

......

]

in the list box, i will have the filed _dimensions to choose.

Everytime, I choose CustomerID, Customer also shows.

here is my condition in dimension tab for the straight table

= SubStringCount (Concat (_dimension, '|'), 'CustomerID')

but when i only choose Cutomer, it is OK.

How do I correct this problem?

Re: dynamic report dimension

Anonymous — Mon, 17 Sep 2012 16:42:55 GMT

Use this condition for Customer dimension (I prefer index to substring, that is not important):

=index(Concat (_dimension, '|'), 'Customer')>0 AND index(Concat (_dimension, '|'), 'CustomerID')=0

Regards,

Michael

Re: dynamic report dimension

alexpanjhc — Mon, 17 Sep 2012 17:17:58 GMT

Michael

when I first chooe CustomerID, it only showed CustomerID---this is good, but when I also choose Customer, Customer does not show any more... looks like it is a conflicts.

Re: dynamic report dimension

Anonymous — Mon, 17 Sep 2012 17:43:32 GMT

I see - the new problem apparently happens when you select both, and I think it works if you select any one of them.

The most relaible way is to change the value 'Customer' so it is not a substring of 'CustomerID' or any other value, for example use 'Customer ' or 'Customer|'.

Regards,

Michael

Re: dynamic report dimension

Tue, 18 Sep 2012 18:11:40 GMT

can somebody kindly explain the exact purpose of the concatenation of the pipe symbol when using substringcount(). I successfully made a dynamic straight table using substringcount(concat(dim_id,'|'),'A') but I don't understand the purpose of the '|'. I know that it works without it partially but not always. The help text for the function does not indicate why I need to combine a value with the pipe. Is it because substringcount needs more than one character to work ?

thank you

Re: dynamic report dimension

alexpanjhc — Tue, 18 Sep 2012 18:19:27 GMT

My understanding is to isolate the words.

eg:if you choose 3 dimensions : customer, order, order date they will become with the pipe line :customr|order|order date.

hyperthetically, if you have a dimension called ror and you do not have the pipe line to separate them,

you will get

customrorderorder date

and the dimension ror will show even if you did not select.

just my 2 cents.

Re: dynamic report dimension

Tue, 18 Sep 2012 18:35:36 GMT

alex - thanks that makes sense - appreciate your reply