Discussion board where members can get started with QlikView.
User selects from '2016','2015','2014' Listbox (Created by inline load below)
However, I am having some issues with linking the below,
LOAD * INLINE [
In my dataset I have the below columns filled with numerical values,
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.
You can deal in two ways:
1) either you call your inline fields as below:
Your dataset as below:
Hope this helps.
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
May be these:
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.