100% Barchart

[robin_heijt]

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

[Zhandos_Shotan · Accepted solution]

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")

[robin_heijt]

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?

[Zhandos_Shotan]

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/Basic...

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...