Splash Screen-1

[#1]

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

[tresesco]

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

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

[rajat2392]

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.

[alexandros17]

Here it is my example

[#5]

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.

[tresesco]

See attached sample qvw.

[alexandros17]

Have you seen my example? It works!

[#8]

There is no attachment

[tresesco]

Is not this visible to you?

[#10]