topic Re: Set Analysis depends upon different Conditions in Visualization and Usability

Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 09:52:16 GMT

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

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 09:54:50 GMT

Chart should be blank, but it should be visible or should it hide? If it should be visible, you can play with GetSelectedCount() function, right?

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 09:57:14 GMT

@sunny Bro No issue can be visible.Yes i Can play with get selected Count. Thanks bro i will try.

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:02:32 GMT

So may be like this:

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

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:06:57 GMT

Max({1}Year) Bro can you explain this

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:08:47 GMT

Max({1} Year) is going to calculate Max(Year) ignoring any selection because I have used {1} in the set analysis.

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:10:02 GMT

Thanks bro i got it.set identitfiers.

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:32:40 GMT

If bro i need same conditions on doctors. if nothing is select then current years doctors other wise according to the years.

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:33:57 GMT

Doctor is an expression or dimension?

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:35:12 GMT

Dimension

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:37:48 GMT

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?

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:39:15 GMT

No bro i want that condition on a filter.

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

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:43:36 GMT

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)

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 10:49:08 GMT

Not working bro.

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

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 10:57:23 GMT

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

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 11:08:35 GMT

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

Re: Set Analysis depends upon different Conditions

sunny_talwar — Mon, 17 Oct 2016 11:46:14 GMT

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

Re: Set Analysis depends upon different Conditions

mohitd910 — Mon, 17 Oct 2016 12:09:19 GMT

Sent . Please check your mail.