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: 
mohitd910
Creator II
Creator II

Set Analysis depends upon different Conditions

Dear Friends,

Requirement is in QlikSense . Not in Qlikview. No Conditional chart is present.

I Have Doctors and Year Like

Doctor     Year                         Revenue

Sunny      2014,2015 ,2016        455667

Manish    2014, 2015                 467787

Arjun       2014, 2015 ,2016        454767

Jagan      2015                           754344

Mohit       2014                            4577



Now Requirement is

1.) if i don't select any thing then current year.

2.)if the doctor is selected Like manish current year is not present then chart should be blank.

3.) but if we select again a year for manish like 2014 in the data should show for the 2014 year. Then it will depend on the selected Year.



Regards,

Mohit Dahiya

17 Replies
sunny_talwar

And what is your expression? This?

Sum({<Year = {"$(=If(GetSelectedCount(Year) = 0, Max({1}Year), Max(Year)))"}>}Revenue)

If this is your only expression then it should already be doing what you are looking for, is it not doing that?

mohitd910
Creator II
Creator II
Author

No bro i want that condition on a filter.

i need to give a filter on the basis of same condition.

sunny_talwar

Oh okay.... I see what you mean... May be try this as your filter expression:

Aggr(Only({<Year = {"$(=If(GetSelectedCount(Year) = 0, Max({1}Year), Max(Year)))"}>}Doctor), Doctor)

mohitd910
Creator II
Creator II
Author

Not working bro.

i need this for a separate  filter or only for list box.

sunny_talwar

I don't see a reason why this wouldn't work. Can you share a sample?

mohitd910
Creator II
Creator II
Author

Bro like

By default sunny and arjun should there in filter for the current year else according to selection.

this is the  filter and list box i need Sunny and arjun  for this year if i didn't select anything else according to the selection.

Capture.PNG selection

sunny_talwar

I am sort of understanding what you mean Mohit, but would you be able to share a qvf to see the issue?

mohitd910
Creator II
Creator II
Author

Sent . Please check your mail.