topic Re: Showing dimensions dinamically in pivot table in QlikView

Showing dimensions dinamically in pivot table

deepakqlikview_123 — Mon, 02 Jun 2014 08:17:41 GMT

Hi all,

PFA.

Can u plz tellme how to select dimensions dinamically in pivot table by using adhoc dimensions.

Plz tell me how it works.

Thanks

Re: Showing dimensions dinamically in pivot table

ashfaq_haseeb — Mon, 02 Jun 2014 08:23:09 GMT

Hi deepak

go through the below post.

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ

Re: Showing dimensions dinamically in pivot table

deepakqlikview_123 — Mon, 02 Jun 2014 08:40:22 GMT

Hi All,

Can u plz tell me how

=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Customer Name|')

will work.

Thanks

Re: Showing dimensions dinamically in pivot table

Mon, 02 Jun 2014 09:03:19 GMT

Hi,

you can you something below in Condition...

=SubStringCount(Concat(CAL,'|'),'YEARS')

Re: Showing dimensions dinamically in pivot table

ashfaq_haseeb — Mon, 02 Jun 2014 09:03:25 GMT

An example could be Substringcount(concat(distinct '|' & MyDimension & '|'), '|ValueA|) will evaluate as true if ValueA is a possible value in MyDimension and false if it's not. So it can be used as a conditional expression to show/hide things depending on what values the user selected. The | characters are to make sure of an exact match.

Regards

ASHFAQ

Re: Showing dimensions dinamically in pivot table

tresB — Mon, 02 Jun 2014 09:05:20 GMT

Deepak,

Let's have a class. .

Then what the SubStringCount does is -> It sees if there is any part of the string like '|Customer Name|' (as mentioned as the second parameter of the function). If it is there then it returns non-zero (position of the sting) which is eventually treated as TRUE.

So when would this condition turns to be true? Well, when you select that value from the Dimension field or nothing is selected at all (because that means all are under scope to be considered), the concat() gets it and produces the string with that value and SubStingCount() finds it and returns a non-zero. If not found, returns zero (FALSE). So this is how your dimension enablilty works conditionally. Hope it helps you comprehend.

Re: Showing dimensions dinamically in pivot table

deepakqlikview_123 — Mon, 02 Jun 2014 09:13:29 GMT

Thanks