topic Re: Differents datasets selected by a user in QlikView

Differents datasets selected by a user

Sat, 19 Aug 2017 16:26:15 GMT

Hi everyone,

I'm starting in the world of qlikview and I have been thinking about a project that I want to do and I don't know if qlikview could be my tool.

The project consists of showing a graph that it contains differents datasets.

The source of this datasets is only one table and I want the users to select this datasets.

For example:

If I have this table:

Country	P. 1960	P. 2016
Belgium	9,153,489	11,348,159
Denmark	4,579,603	5,731,118
Iceland	175,574	334,252
Germany	72,814.90	82,667.68
Ireland	2,828.60	4,773.10
New Zealand	2,371,800	4,692,700

and I have a user who select, for example, Iceland and Ireland, and there is another user who select Denmark, Belgium and Germany.

Can I have with qlikview two datasets selected by this two users? And could this two dataset be ploted in a graph by two differentes lines?

Thank you in advance and have a nice day.

Re: Differents datasets selected by a user

Anil_Babu_Samineni — Mon, 21 Aug 2017 08:07:25 GMT

I think, yes by help of Alternate states you can achieve this?

Re: Differents datasets selected by a user

Tue, 22 Aug 2017 16:29:56 GMT

Hi Anil, thanks for your reply,

yes, it could be a possibility but I don't know how many datasets I have to create and doing this action with alternate states involves creating an indeterminate number of copies of the table.

Could I define different variables and assing them ditinct datasets?

Thanks in advance