Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
artempotsuray
Contributor III
Contributor III

Data Tables with Drop Down

Hello everyone,

I have a question about condensing my data table. Currently my table has what is shown in the image below. My question is, is there a way for me to condensing the Gage Number catagory to show only the most recent EVENT_DATE but to still have a drop down like in pivot tables so that when I need to look at the previous event dates I can do so on the same table and not have to create another table.

Condensing gages.PNG

Any help is appreciated

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Create two tables. The first shows only the latest date. Add Gage Number and GAGE_DESCR as dimensions and max(EVENT_DATE) as expression. The second table is the one you have now, but you add a calculation condition so it won't show any records unless you first select one Gage Number: =GetSelectedCount([Gage Number])=1


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
ogautier62
Specialist II
Specialist II

Hi

here on this dummy data :

last ticket shown for each item

with i=0 :

with as dimension for ticket :

if(i=1,if(NoTicket = aggr( nodistinct max(NoTicket),Article),NoTicket),NoTicket)

so in your case, something like :

if(i=1,if(date_event = aggr( nodistinct max(date_event),Article),GageNo),GageNot)

you can use a button to chage i too

regards

Gysbert_Wassenaar

Create two tables. The first shows only the latest date. Add Gage Number and GAGE_DESCR as dimensions and max(EVENT_DATE) as expression. The second table is the one you have now, but you add a calculation condition so it won't show any records unless you first select one Gage Number: =GetSelectedCount([Gage Number])=1


talk is cheap, supply exceeds demand
artempotsuray
Contributor III
Contributor III
Author

I have something similar to this. Now it shows only the most recent event date but the next step for me is to try to make a drop down on each Gage number so that when it is selected it would show the previous event dates as well as the most recent one. Is this possible?

artempotsuray
Contributor III
Contributor III
Author

This works but for aesthetic purposes on my sheet, is it possible to make this info as a drop down instead of creating a new table?

Gysbert_Wassenaar

No


talk is cheap, supply exceeds demand
artempotsuray
Contributor III
Contributor III
Author

Ok thanks for your help