Adding a parameter in Qlik Sense

[Anonymous]

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

[Anonymous]

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

[rwunderlich · Accepted solution]

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

[Anonymous]

Thanks Rob for your response.

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

-Nishtha