topic Re: 100% Barchart in App Development

100% Barchart

robin_heijt — Thu, 22 Nov 2018 12:57:15 GMT

Hi,

So I know that in order to create a 100% Bar chart you use the expression Count(Field)/Count(total <Field> Field)

What I am wondering about now is if someone can explain to me how the second part of the expression works.

Why am I using <> to specify my main dimension, and what does it mean.

Reason for asking is that I am trying to figure out how I can make my 100% bar chart ignore a specific filter by using {<"Field"=>}. But don't seem to be able to use this expression in combination with the <> part.

Anyone that would potentially be able to explain how to use my expression:

Count(distinct[Field])/count(distinct total <Field> "Field")

And then adding in {<"IgnoreFilter"=>} to ignore a field.

Thanks

Re: 100% Barchart

Zhandos_Shotan — Thu, 22 Nov 2018 13:08:04 GMT

Hi!

You can use combination of Set Analysis and Total in mosttype of expressions. I dont see any problem here ).

Just add it into expression like this:

Count( {<"IgnoreFilter"=>} distinct[Field]) / count( {<"IgnoreFilter"=>} distinct total <Field> "Field")

Re: 100% Barchart

robin_heijt — Thu, 22 Nov 2018 14:36:51 GMT

Thanks, I went wrong by placing the ignore expression part after "distinct"

Could you still explain to me what the "<>" part entails? Why do we use the arrows exactly?

Re: 100% Barchart

Zhandos_Shotan — Fri, 23 Nov 2018 04:51:05 GMT

Use <Arrows> for list of fields in Total qualifier and in Set modifier in Set analysis.
To disregard the dimensional grouping – Use the Total qualifier. Syntax for Totals: Total<Field1, Field2, Feild3>
To disregard the selection – Use Set Analysis
<Set modifier> is key part of {Set analysis} where you define list of fields and values that should be filtered.
Syntax examples for Set modifiers Field values :
<field1={'Value1','Value2'}, field2={"<=Value"}, field3={"<=$(=Expression)"}>

Pls ref to manuals below:
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAggregationFunctions/sum.htm

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers.htm