topic Re: Multiple selections in QlikView

Multiple selections

Thu, 20 Nov 2014 16:41:43 GMT

Hi,

Is there any way to show selected value and its benchmark in same bar chart?.

Like If I select Client name ='Acer' then all the clients having Industry as Computer hardware(Filter 3) should show up in chart irrespective of my client Name selection.

Output should be Acer + Other clients from same Industry.

Regards,

Navdeep

Re: Multiple selections

jerem1234 — Thu, 20 Nov 2014 18:11:48 GMT

Maybe you can take use of the p() function in set analysis, an expression might look like:

sum({<[Client Name]=, Industry = p(Industry)>}Sales)

Hope this helps!

Re: Multiple selections

Sat, 22 Nov 2014 16:32:50 GMT

Hi Jeremiah,

Thanks for the time. It's working but now bar chart is showing aggregation based on industry. but required is bar for each client.

Is there any way to show 'value' of all clients having same industry. Metric is in dimension and sum({<[Client Name]=,Industry=p(Industry)>}Value) is expression.

Appreciate your help.

Regards,

Navdeep

Re: Multiple selections

stevedark — Sun, 23 Nov 2014 21:47:09 GMT

It should work if you simply change the dimension in the chart to Client Name

If you look up posts on 'brushing' you can use a technique where only one chart is used. Clients in your selection being shown in one colour and those that are in the same industry in another.

Basically you would use an expression like Jeramiah suggests then set up a colour expression something like:

if(isnull(maxstring([Client Name])), rgb(180,180,180), rgb(50,200,50))

The maxstring will only return non null if the client is in the selection, not just the same industry.

Steve

Re: Multiple selections

nagaiank — Mon, 24 Nov 2014 01:54:58 GMT

If the number of clients and industries are not large, you may use the following script. Create list box on the field Client1 and user the field Client as dimension in your chart objects.

load * Inline [

Client, Industry

Acer, Computer Hardware

Dell, Computer Hardware

HP, Computer Hardware

Gateway, Computer Hardware

Oracle, Software

SAP, Software

SAS, Software

Qlik, Software

];

Outer Join (A) LOAD Client as Client1, Industry as Industry1 Resident A;

NoConcatenate

LOAD Client, Client1 Resident A where Industry = Industry1;

Drop Table A;

Re: Multiple selections

jagan — Mon, 24 Nov 2014 02:08:55 GMT

Hi,

Try like this

Dimension: [Client Name]

Expression: sum({<[Client Name]=,Industry=p(Industry)>}Value)

Or if you want two bars one for Acer and other for all other clients then use this

Dimension:

If([Client Name] = Only([Client Name]), [Client Name], 'All Other Clients')

Expression:

sum({<[Client Name]=,Industry=p(Industry)>}Value)

Hope this helps you.

Regards,

Jagan.

Re: Multiple selections

Mon, 24 Nov 2014 03:03:39 GMT

Hi,

sum({<METRIC_NAME={'Store Level Visibility'},CLIENT_NAME=,INDUSTRY=p(INDUSTRY)>}METRIC_VALUE)

This expresion has worked for me.Thanks for the detailed explanation.

Regards,

Navdeep Kumar

Re: Multiple selections

jagan — Mon, 24 Nov 2014 03:06:39 GMT

Hi,

Please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.

Re: Multiple selections

rwunderlich — Mon, 24 Nov 2014 03:12:06 GMT

I don't think the

,INDUSTRY=p(INDUSTRY)

is necessary. You should be able to remove that and simplify.

-Rob

Re: Multiple selections

Mon, 24 Nov 2014 03:35:06 GMT

Hi Rob,

I tried without Industry=p(Industry), then all clients are showing up in chart irrespective of industry. I need to show clients having same industry, thus P(Industry) is required I guess.

Regards,

Navdeep

Re: Multiple selections

rwunderlich — Mon, 24 Nov 2014 03:43:06 GMT

Got it. My misunderstanding, I thought an Industry was selected.

-Rob