Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
];
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
Hi,
thanks a lot. I will try to implement it tonight (QlikSense is more of a Hobby)
BR,
Daniela