Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
No bro i want that condition on a filter.
i need to give a filter on the basis of same condition.
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)
Not working bro.
i need this for a separate filter or only for list box.
I don't see a reason why this wouldn't work. Can you share a sample?
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.
selection
I am sort of understanding what you mean Mohit, but would you be able to share a qvf to see the issue?
Sent . Please check your mail.