topic Re: Create Multiple Reports Dynamically in QlikView

Create Multiple Reports Dynamically

Anonymous — Mon, 03 Feb 2014 14:57:46 GMT

I have some User Specific records like .... User Name, Address, DOB etc.

We have requirement to show single or multiple report based on each USER selection.

For example:

If I select 1 User I should see user details in once container >>>> text box.

If I select 2 Users I should see 2 container having each 2 user details......and so on.

Containers can be aligned one below the other.

QlikView Experts Plzzzzzzzzzzzz Help.

Re: Create Multiple Reports Dynamically

jvitantonio — Mon, 03 Feb 2014 15:03:24 GMT

Hi,

You can hide/show the container or any object with the Show Conditional option in the Layout tab.

you can then put there something like this "If(myField = 'User1', 1,0)"

I hope this helps.

Re: Create Multiple Reports Dynamically

Anonymous — Mon, 03 Feb 2014 15:09:19 GMT

Hi,

Yes this will help for displaying container.

But dynamically fetching data in each container is an issue.

for example:

in filter if we select 1 or more user - (name, address, DOB) . How to display data in different containers.

Thanks,

Shree

Re: Re: Create Multiple Reports Dynamically

jvitantonio — Mon, 03 Feb 2014 15:15:32 GMT

See the attached QVW

Re: Create Multiple Reports Dynamically

Anonymous — Mon, 03 Feb 2014 15:21:28 GMT

Awesome. That will work.

=substringcount(concat(User,'*'),'User1')

In real scenario we have many users ..... can we pass User1 & User2 & User3....... too dynamically

Re: Create Multiple Reports Dynamically

Anonymous — Mon, 03 Feb 2014 15:22:02 GMT

The easy way is to use straight table with columns User Name, Address, DOB... One line is one "user report". I'd use this one.

There could be many hard ways. An example od a hard way is to pre-build multiple (but fixed) number of "reports" in any form or shape. Locate them one below the other. Make 1st one visible if at least one user selected, 2nd - if at least two users selected, etc.
Use some logic in each report so you show data for user one in 1st report, user 2 in 2nd, ... For example, use FirstSortedValue() function:

1st.
User Name: FirstSortedValue("User Name", USERID, 1)
DOB: FirstSortedValue(DOB, USERID, 1)
...
2nd.
User Name: FirstSortedValue("User Name", USERID, 2)
DOB: FirstSortedValue(DOB, USERID, 2)
...

I hope you can figure out from here. But my primary recommendation is to use table.

Re: Create Multiple Reports Dynamically

Mon, 03 Feb 2014 15:36:19 GMT

Shree,

In fact, there are two questions

1) Displaying or hiding the text boxes

I think you can show it, conditionnaly, in the Layout tab

GetSelectedCount(Client) >=N (where N is your Nth box)

2) Displaying the content

In your model, if you do not have duplicates (each client has his own details once in a table)

you can use concat() and subfield() functions

concat(Distinct ClientAttributeN, '|', Client) : will create a string of the attribute N for the clients, ordered by Clients (and not by the attribute. The fields are separated with the pipe '|' or whatever that cannot be in the field values

substring(string, '|', N) will return the the Nth field of the string

=> so by encapuslating both

substring(concat(FieldAttributeN, '|', Client), '|', 2) : you will get the attribute of the second client

Fabrice

Re: Re: Create Multiple Reports Dynamically

Anonymous — Mon, 03 Feb 2014 16:26:51 GMT

Try attached. Make selections in USERID box, and see how "reports" react.