topic Re: Changing fields for formulas with selection outside the formula itself in QlikView

Changing fields for formulas with selection outside the formula itself

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

Hi, I would like to define a visuasilation based on changing fields, i.e. I have five fields and want to be able to select them by a filter? drop-down list? and then the field should be the basis for a formula. Can anybody tell me how to do this? Thanks, Daniela

Re: Changing fields for formulas with selection outside the formula itself

Gysbert_Wassenaar — Thu, 04 Jan 2018 17:43:39 GMT

If you're using Qlikview you can create a Cyclic group that contains the five fields. You can use the group as dimension in the chart.

Or you can use create small extra table in the script that contains the field names:

FieldsForSelection:

LOAD * INLINE [

FieldName

Store

Product

Brand

Customer

Salesperson

];

Add a listbox for the FieldsForSelection field. Select one value and then enable the Always One Selected Value option in the properties of the listbox.

You can then use a calculated dimension like =$('[' & Only(FieldName) & ']') as dimension in the chart.

Re: Changing fields for formulas with selection outside the formula itself

devarasu07 — Thu, 04 Jan 2018 17:57:54 GMT

Hi,

Refer to the attached sample,

Dimension:

=$(=only(Dimension))

Measure:

sum(Sales)

fyi, below is back end script

Fact:
Load * Inline [
Year,Country,Product,Sales
2015,India,A,1500
2016,India,B,2200
2017,India,C,3050
2015,Singapore,1950
2016,Singapore,2060
2017,Singapore,3500
];
Dimensionlist:
Load * Inline [
Dimension
Year
Country
Product
];

Re: Changing fields for formulas with selection outside the formula itself

Anonymous — Fri, 12 Jan 2018 09:48:11 GMT

Dear Gysbert,

thanks a lot and sorry for the delay in answering. QlikSense is more of a hobby... I will try to implement, even though my trial gave me an Syntax error regarding "LOAD * INLINE [". It might be the language.

BR,

Daniela

Re: Changing fields for formulas with selection outside the formula itself

Anonymous — Fri, 12 Jan 2018 09:49:21 GMT

Hi,

thanks a lot. I will try to implement it tonight (QlikSense is more of a Hobby)

BR,

Daniela