topic Selecting all options in a listbox in QlikView

Selecting all options in a listbox

Thu, 12 Feb 2015 12:33:52 GMT

Hi,

I have a region(ID) listbox...

i want to show all the regions even though a particular region is selected. i have done that using the set expression.

However, i am unable to replicate the same for my 2nd expression as a result of which instead of a complete line i can see a single dot (value for selected region)....

can we add the same criteria in the 2nd expression so that it shows trend for all regions?

have atatched my file for reference.

thanks in advance.

Re: Selecting all options in a listbox

rubenmarin — Thu, 12 Feb 2015 12:51:48 GMT

Hi, you can apply the same set analysis to each aggregation function in second expression:

=If(GetSelectedCount(Division)=0,((Sum({< ID= >}[Time to complete])/Sum({< ID= >}Time)*Sum({< ID= >}Resource))*0.1)+(Sum({< ID= >}[Time to complete])/Sum({< ID= >}Time)*Sum({< ID= >}Resource)),(Sum({< ID= >}[Time to complete])/Sum({< ID= >}Time)*Sum({< ID= >}Resource)))

Re: Selecting all options in a listbox

Gysbert_Wassenaar — Thu, 12 Feb 2015 12:52:36 GMT

can we add the same criteria in the 2nd expression so that it shows trend for all regions?

Have you tried it?