topic Re: Adding a parameter in Qlik Sense in App Development

Adding a parameter in Qlik Sense

Anonymous — Mon, 15 Oct 2018 21:20:57 GMT

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

Re: Adding a parameter in Qlik Sense

rwunderlich — Tue, 16 Oct 2018 05:30:30 GMT

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

-Rob

Re: Adding a parameter in Qlik Sense

Anonymous — Tue, 16 Oct 2018 14:51:14 GMT

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

-Nishtha

Re: Adding a parameter in Qlik Sense

rwunderlich — Tue, 16 Oct 2018 15:59:46 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Tue, 16 Oct 2018 16:57:25 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Tue, 16 Oct 2018 17:05:29 GMT

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

Re: Adding a parameter in Qlik Sense

rwunderlich — Wed, 17 Oct 2018 13:01:41 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Wed, 17 Oct 2018 15:26:45 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Wed, 17 Oct 2018 17:46:11 GMT

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

Re: Adding a parameter in Qlik Sense

rwunderlich — Thu, 18 Oct 2018 20:25:55 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Wed, 24 Oct 2018 16:48:05 GMT

Hey Rob,

In the very scenario, say I have taken Region in my drop down and I want to show countries in the 2 line charts say A and B like countries starting with U should go to graph A and starting with I should go to graph B and region is common for both the charts. So, how to filter the records in the measure expression on the basis of region entered as each region has got its own set of countries starting with U and I respectively?

Thanks in advance!

-Nishtha

Re: Adding a parameter in Qlik Sense

rwunderlich — Mon, 29 Oct 2018 11:19:01 GMT

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

Re: Adding a parameter in Qlik Sense

Anonymous — Tue, 30 Oct 2018 16:25:03 GMT

Thanks Rob for your response.

I used Sum({$<Country={"U*"}>}[Sales]) and is working fine. Does $ create any difference in the expression?

-Nishtha