Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding a parameter in Qlik Sense

Hi,

How can we add parameters in the report of Qlik Sense?

Suppose I want to generate many reports on the basis of the parameter being entered.

Thanks,

Nishtha Garg

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The filtering by Region selection is automatic as part of the Qlik Associative model  That is the beauty and power of Qlik.

If you want to each chart to represent different countries as you described, then you would use a set expression with a wild card such as:

Sum({Country={"U*"}}Sales)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com

View solution in original post

12 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What do you mean by reports? Do you mean charts?  Or are you using Nprinting to generate printed reports?

-Rob

Anonymous
Not applicable
Author

When I have to depict on line charts so that the chart changes according to the parameter being passed.

-Nishtha

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can add a set expression, that sets certain values, to your aggregation functions.  So for example if you wanted your chart to show only data belonging to the Region=EU.

Sum({<Region={'EU'}>} Sales)

Is that what you are looking for?

-Rob

Anonymous
Not applicable
Author

Thanks for your response.

I am kind of looking for this. Additionally,what if I want various line charts one after the other on the basis of regions. The solution proposed by you is only for EU right.So, do I need to hard code the value for each region in separate charts? Apart from it, can we apply two parameters in one aggregate function,say country along with region? Sorry I am new to the Qlik world. My question could be silly but it is where I am stuck at currently.

-Nishtha

Anonymous
Not applicable
Author

I got how to set multiple parameters like country with region. I am left with only the first question now.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The option you are looking for, to automatically generate a chart for each value of a dimension, is called "trellis". It's available in QlikView but not native Qlik Sense For Sense you will need to install an extension. There is one here:

https://github.com/miclae76/trellis-chart

but it appears to not be actively maintained.

-Rob

Anonymous
Not applicable
Author

Thanks Rob for your response.That means the extension of trellis chart would lead the charts generate dynamically according to the dimension values. Apart from it, there is no way to represent multiple charts on the basis of region except to make one and hard code the values.

-Nishtha

Anonymous
Not applicable
Author

Hey Rob,

We have one more extension for drop down menu. So,if we select region for the dropdown, how can we link it to the line chart according to the value of the region selected?

-Nishtha

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You don't need an extension.  Just use a standard filter pane.  Select the Region and you will automatically limit the line shart to that Region.

-Rob