topic Re: Splash Screen-1 in QlikView

Splash Screen-1

Thu, 08 May 2014 07:26:05 GMT

Hi All,

Please can you help me with the below scenario, I am new to Qlik view.

- Have a table with Country and Dates

1) Want to create a dashboard which shows Distinct Countries and Max( Date) for that country

2) When I click on the country it should take me to a new tab which shows all the dates in the table for that country for the current month.

Thanks

Avinash

Re: Splash Screen-1

tresB — Thu, 08 May 2014 07:29:37 GMT

1) Create a straigth table, dimension:Country, Expression: =Date(Max(DateField))

2) Use a trigger: Field Event-> On Select->Action(Layout)->Activate Sheet

Re: Splash Screen-1

rajat2392 — Thu, 08 May 2014 07:34:14 GMT

Hi Avinash

1) as tresesco told, same

2) Go to Document Properties>>Triggers Tab>>Field Trigger>>OnSelect

here you add action OnSelect as activating the new sheet and give the sheet Id. In that sheet have a table with the dimension as Country and expression as dates.

Re: Splash Screen-1

alexandros17 — Thu, 08 May 2014 07:37:55 GMT

Here it is my example

Re: Splash Screen-1

Thu, 08 May 2014 07:56:26 GMT

Thanks.

I have

- a fact table - with dates and country keys and measures

- Dimension with country details

I want to display which countries present in fact and max of date.

e.g:

Country Dates

India May 05 2014

NY May 03 20134

When i click on India

It should show us which all dates for india in fact are available for May 2014.

India May 01 2014

May 02 2014

May 05 2014

Thanks.

Re: Re: Splash Screen-1

tresB — Thu, 08 May 2014 08:57:44 GMT

See attached sample qvw.

Re: Splash Screen-1

alexandros17 — Thu, 08 May 2014 09:01:33 GMT

Have you seen my example? It works!

Re: Re: Splash Screen-1

Thu, 08 May 2014 09:16:31 GMT

There is no attachment

Re: Re: Splash Screen-1

tresB — Thu, 08 May 2014 09:20:00 GMT

Is not this visible to you?

Re: Re: Splash Screen-1

Thu, 08 May 2014 09:35:26 GMT

Re: Re: Splash Screen-1

tresB — Thu, 08 May 2014 09:46:49 GMT

Try using a different browser.