Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If i have a table, that has 3 fields in, Computer Name, Installation Data and Group Name, how can i filter the table to show a count of installations by computer name, by group ?
I can build my table to show count by computer name, but i need to filter this by a certain group name,so how would i filter the table below to only show Group A entries?
I tried adapting Brian's set analysis expression from https://community.qlik.com/message/834250?et=watches.email.thread#834250 for this but didn't work.
Thanks
example:
Computer Name Installation Date Group Name
TGF-098 12/04/2015 Group A
TGF-093 12/04/2015 Group A
TGF-012 12/04/2015 Group B
TGF-011 12/04/2015 Group C
TGF-087 12/04/2015 Group B
TGF-014 12/04/2015 Group D
Hi Paul, thanks for your participation in the Qlik Community.
I branched this to a new discussion thread. Our members will review.
Regards,
Mike T
Hi Paul,
In this case, just add another clause to your set analysis expression. For example:
Count({$<[Priority Id]={1}, [Group Name]={'Group A'}>}[Task Number])
Note that if you are doing a text comparison, you must enclose the evaluated expression in single quotes. For a numeric comparison, no quotes are needed.
Hope that helps.
Regards,
Brian
Brian, As always thankyou for the prompt replies and help.
how would i just set a very simple filter on the table to just show anything related to Group A, i don't need a count function or anything just filter the table to show anything relating to Group A?
Thanks
Hi Paul,
In this case, you don't necessarily need set analysis.
Just drag the field Group Name onto the canvas and a filter pane will be created. Then just select, Group A.
It's that easy...i think
Does that make sense?
Regards,
Brian
Brian, that makse perfect sense, and it does work, the only problem is users can still change the filter if they want to, and the filter is visible, i need to add a filter so that ONLY group A entries show in the table, the rest are hidden and the user cannot alter this. (but i don't want to filter other groups out at load time so this isn't an option to ONLY bring in Group A data)
Any ideas?