topic Re: Hardcode Customers in a Chart. in QlikView

Hardcode Customers in a Chart.

JustinDallas — Fri, 17 Apr 2015 15:54:14 GMT

Hello Everyone,

I have a requirement to build out a chart, with a group of Customers. This groups isn't definable by data, but is more of a "I want these customers on this list I'm giving you to appear in a Chart". My question is, how do I make that happen when there is no Set Analysis that I can run on as the list of Customers don't really have a grouping characteristic.

I've attached a picture of what I am trying to achieve.

Any help on this hard coding issue is greatly appreciated.

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 15:58:17 GMT

How will these customers be defined? Do you want to input them manually in a grid in the application or could they just be listed in a spreadsheet that you read during reload?

Re: Hardcode Customers in a Chart.

JustinDallas — Fri, 17 Apr 2015 16:00:23 GMT

I'll be given a list of names. I can input them manually just to meet the requirement for the near future, but I assume that in the distant future, I will want them in a spreadsheet with their unique business keys.

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 16:01:14 GMT

You can connect it via the data model and key-fields and also use variables and $-sign expansion to achieve it.

Re: Hardcode Customers in a Chart.

sunny_talwar — Fri, 17 Apr 2015 16:01:47 GMT

Explore the possibility of using ValueList() function with either INPUTFIELD or InputBox Object.

Sunny

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 16:01:50 GMT

I'll hash together a quick demo for you...

Re: Hardcode Customers in a Chart.

giakoum — Fri, 17 Apr 2015 16:07:59 GMT

Users can map/group dimensions at run-time!

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 16:12:45 GMT

Actually the quickest way of doing it is to use a straight-forward search in a list-box containing customer names or customer ID's. You can in the search in the title of the list-box write:

Re: Hardcode Customers in a Chart.

JustinDallas — Fri, 17 Apr 2015 16:16:59 GMT

Maybe I ill-posed the question. The chart is going to be made for a report, so we need to have the chose customers stuffed into the chart well before the user goes into it.

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 16:18:04 GMT

You can have a simple input box with one variable named v1 and then use this expression in your chart to list only those customers you put into the list-box:

Sum( { <Customer={$(v1)}>} Amount)

the v1 should contain:

'Customer 1','Customer 45','ACME INC'

Re: Hardcode Customers in a Chart.

Anonymous — Fri, 17 Apr 2015 16:18:36 GMT

What prevents you from using select?

Re: Hardcode Customers in a Chart.

JustinDallas — Fri, 17 Apr 2015 16:29:17 GMT

What's select?

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 16:30:56 GMT

Doing a selection in a listbox or directly in the chart (if it is a straight table).....

Re: Hardcode Customers in a Chart.

JustinDallas — Fri, 17 Apr 2015 21:37:09 GMT

Long story short, I just put the keys into a spreadsheet, and joined them with my Fact table and setting a 1 on the items of importance.

Re: Hardcode Customers in a Chart.

petter — Fri, 17 Apr 2015 21:42:20 GMT

Nice and simple often does it