Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna789
Creator
Creator

How to select multiple Measures in qliksence ?

Hi experts,

i  want to select multiple  Measures has show in figure ,like  at a Time i will select 2 measures or 3,measures .

Multiple_Measures_.png

Thanking You

krishna

stevedarkmartinpohlmtosbkumar577 

5 Replies
dsharmaqv
Creator III
Creator III

Put button and enable measure condition to appear on click.

krishna789
Creator
Creator
Author

Hi Deepak Sharma,

Can You Elaborate ,pls share app .what is put button

Thanking You

krishna

undergrinder
Specialist II
Specialist II

hi Krishna,

look at this extension:

Qlik Branch

This may help you.

---

You define 3 variable to measure1..3, and to the chart you add a condition, to show the data only when the variable contains true. With the extension you can modify the value of the variable. I'm not sure, that this way suit you, because all measure will there, even if all value is null because of the variable and the condition in measure.

It is easier and more elegant the cyclic measure, you find a tutorial here:

Cyclic Measures in Qliksense

But with cyclic measures, you can't compare the bars, only changing the measure behind them.

G.

martinpohl
Partner
Partner

there is an example attached but:

You can't do this with Qlik Sense in bar chart (or any other non table chart) right now - without an extension.

With version Jun 2018 there is an option to show expressions by calculation, but only in table charts.

Regards

stevedark
Luminary Alumni
Luminary Alumni

Hi,

You may be able to get to what you want by using the ValueList function as the dimension and then have a single expression which returns a value for each of the types.

There is an example of using ValueList in the bottom section of this blog post:

https://www.quickintelligence.co.uk/qlik-target-bar-chart/

In your case you will want to load the Measures to choose as a data island, you can then have a filter to select which dimensions are in or out.

You may be able to have a Calculated Dimension of;

ValueList(chr(39) & concat(Measures, chr(39) & ',' & chr(39)) & chr(39))

This may then produce a list of selected measures as a dimension, e.g.

ValueList('Measure 1', 'Measure 3')

You can then use the ValueList to drive the expression, like this:

if(ValueList(chr(39) & concat(Measures, chr(39) & ',' & chr(39)) & chr(39)) = 'Measure 1',

     sum(Something),

if(ValueList(chr(39) & concat(Measures, chr(39) & ',' & chr(39)) & chr(39)) = 'Measure 2',

     sum(SomethingElse), sum(AnotherThing)))


It's a bit fiddly, and you will have to experiment a bit, but I hope that points you in the right direction.


Steve