If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am having one scenario,.
I am using Ad hoc report in Qliksense by using multiple dimensions and multiple expressions.
Base expression is : Sum(sales)/ Sum(Total Sales).
Here if i'm adding region has dimension, Expression should like - sum(sales)/sum(Total<Region> Sales)
If i included one more dimension , expression should like - sum(sales)/sum(Total<Region,Area>sales)
Means, if i selected any dimension it is going to add or remove from denominator after total qualifier.
Any suggestions ?
Thanks in Advance.
As you said, you are using Adhoc repot. for that, Perhaps this?
If(GetSelectedCount(Dimension)=0, Sum(sales)/ Sum(Total Sales), Sum(sales)/ Sum(Total <$(=Concat(DISTINCT Dimension, ','))> Sales))
Thanks for your reply. But i am getting null values in the expression.
Please replace the Dimension field with input field?
Anil - I want to add / remove fields dynamically from selected dimension values.
With input filed i'm not able to get the expected result.(Measure is not going to calculate - Giving null values).
is there any solution with Substringcount(Concat()) - ?
Thanks in Advance
Should be possible
=SubStringCount('|' & $(=Concat(distinct Dimension, '|')) & '|', '|Measure1|')
TRy this in Text object and see?
$(=Concat(distinct Dimension, '|'))