Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
1) Create a straigth table, dimension:Country, Expression: =Date(Max(DateField))
2) Use a trigger: Field Event-> On Select->Action(Layout)->Activate Sheet
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.
Here it is my example
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.
See attached sample qvw.
Have you seen my example? It works!
There is no attachment
Is not this visible to you?