Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

Hmmm, it'll be interesting to see other comments from the community.

I've done it but instead of a filter pane I've used a straight table, with the project name as the dimension and a measure such as this one: Count({<Flag = {'Ending'}>} [NAME OF PROJECT (Code - Title)])

I hope this helps,

Cheers,

Luis

View solution in original post

6 Replies
luismadriz
Specialist
Specialist

Hmmm, it'll be interesting to see other comments from the community.

I've done it but instead of a filter pane I've used a straight table, with the project name as the dimension and a measure such as this one: Count({<Flag = {'Ending'}>} [NAME OF PROJECT (Code - Title)])

I hope this helps,

Cheers,

Luis

woshua5550
Creator III
Creator III

these two expressions will work if you just want get the list

=ValueList($(=Concat({<Flag = {Starting}>}Chr(39) & [NAME OF PROJECT (Code - Title)]& Chr(39),',')))

=ValueList($(=Concat({<Flag = {Starting}>}Chr(39) & [NAME OF PROJECT (Code - Title)]& Chr(39),',')))

微信截图_20171127173836.png

however , you can't use it as filter any more

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

In your case you can use

=if(Date=Start,[NAME OF PROJECT (Code - Title)])

for your Start filter and:

=if(Date=End,[NAME OF PROJECT (Code - Title)])

for your end Filter

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

luismadriz
Specialist
Specialist

Oh I think I got it,

Please try with this on the filter pane:

=AGGR(Only({<Flag = {'Ending'}>} [NAME OF PROJECT (Code - Title)]),[NAME OF PROJECT (Code - Title)])

Untitled.png

It makes all the difference that you've sent a qvf,

Cheers,

Luis

luismadriz
Specialist
Specialist

I forgot:


PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others