topic Re: dynamic report in QlikView

dynamic report

shrusrkt — Wed, 25 Nov 2020 16:16:04 GMT

I have created dynamic report. here on selection one field come but I want current selection of two or three fields on selecting dimension. So what would be the Inline for the same

Re: dynamic report

trdandamudi — Wed, 17 May 2017 18:48:23 GMT

When you click and drag in the list box, you will be able to select multiple fields and it will reflect in the details chart. Can share a sample app ?

Re: dynamic report

trdandamudi — Wed, 17 May 2017 18:59:10 GMT

If you are not able to select multiple in the list box, then make sure you remove the check for "Always One Selected Value".

Hope this helps...

Re: dynamic report

Digvijay_Singh — Wed, 17 May 2017 20:55:24 GMT

Can you share dimensions and expression of your report, are you controlling dimensions display in the report shown in the middle using dimension enable condition? More info will help to understand the problem.

Re: dynamic report

Anonymous — Wed, 17 May 2017 21:10:47 GMT

I'm assuming you're using conditional show expression. So to do more than one it would be something like.

=SubStringCount('|' & Concat(distinct DIM, '|') & '|', '|TASKACT_SRNO|')

and you would replace TASKACT_SRNO for each dimension.

Re: dynamic report

shrusrkt — Thu, 18 May 2017 10:35:46 GMT

I have used this expression.

=SubStringCount(Concat(DIM , '|'),'TASKACT_SRNO')

Re: dynamic report

Anonymous — Thu, 18 May 2017 16:06:55 GMT

Glad you got it working!