topic Re: Load inline values and link with Chart in QlikView

Load inline values and link with Chart

hatherst — Wed, 25 Nov 2020 16:16:04 GMT

User selects from '2016','2015','2014' Listbox (Created by inline load below)

However, I am having some issues with linking the below,

LOAD * INLINE [

Year

2016

2015

2014

];

In my dataset I have the below columns filled with numerical values,

2016 Sales
2015 Sales
2014 Sales

How can the Pivot Table and Pie Chart update as per user 'Year' selection?

I do not want to create 3 Charts but would rather keep it 1 Dynamic Chart that changes with 'Year' selection.

It should be something with regards to conditions/expression in both Pivot Table and Pie Chart but I am not sure of how to do it.

Would appreciate your help.

Re: Load inline values and link with Chart

trdandamudi — Mon, 24 Sep 2018 15:40:49 GMT

You can deal in two ways:

1) either you call your inline fields as below:

2016 Sales

2015 Sales

2014 Sales

Your dataset as below:

2016

2015

2014

Hope this helps.

Re: Load inline values and link with Chart

MK9885 — Mon, 24 Sep 2018 17:14:53 GMT

Maybe use Keepchar in your Original data set?

Keepchar( YearSales, '0123456789') as Year

You can now use Year in front end with out creating an Inline table since this new field is created from your fact table it will work for all your charts

Re: Load inline values and link with Chart

BalaBhaskar_Qlik — Mon, 24 Sep 2018 17:34:00 GMT

May be these:

=num(Sum({1<Year={'$(=getfieldselections(Year))'}>} Sales),'0.00')

Sum({$<Year={'$(=getfieldselections(Year))'}>} Sales)

Re: Load inline values and link with Chart

BalaBhaskar_Qlik — Mon, 24 Sep 2018 17:34:30 GMT

Sum({$<Year=p(Year)>} Sales)

Re: Load inline values and link with Chart

marcus_sommer — Tue, 25 Sep 2018 12:28:29 GMT

In most cases it's better to resolve the multiple sales columns within a single column for sales and one for your period per The Crosstable Load‌. With this no extra logics to select the values will be needed.

- Marcus