Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

d_ankusha
Contributor II

Excel in Qlik Sense

Hi,

I want to have certain fields from excel file taken as a condition in my Sense application. How can I do that?

1 Solution

Accepted Solutions
MVP
MVP

Re: Excel in Qlik Sense

You can read the fields that should be condtions into a table in the load script. From that table you can use the Peek() function afterwards and create variables. These variables can be used in conditions both in the load script and/or in the UI later on.

Do you have more specific sample data to illustrate how you would want it to work that you could create and share with us?

3 Replies
MVP
MVP

Re: Excel in Qlik Sense

You can read the fields that should be condtions into a table in the load script. From that table you can use the Peek() function afterwards and create variables. These variables can be used in conditions both in the load script and/or in the UI later on.

Do you have more specific sample data to illustrate how you would want it to work that you could create and share with us?

d_ankusha
Contributor II

Re: Excel in Qlik Sense

I have Condition.xls file. Here the Leader name is associated with another sales table. The rest of the fields i.e. Include, exclude and date are supposed to be conditions for which the last column i.e 50% calc. is to be calculated.

MVP
MVP

Re: Excel in Qlik Sense

You could filter your data directly without using variables by having a set expression in you charts aggregation functions.

Sum( {<Include = {'Yes'},Exclude -= {'Yes'},Date={'$(=If(Len(Date)>0,''>''&Date,''*'')'}>} Sales )