Discussion board where members can get started with Qlik Sense.
I Want to create funnel chart ... so i have a Inline Table Say,
Load * Inline
"KPI Funnel", FunnelViewDimOrder
And in funnel chart .. I have a Dimension [KPI Funnel]
And Expression :
if([KPI Funnel]='Leads', Count(distinct LeadID),
if([KPI Funnel]='Spend',Sum(Spends),if([KPI Funnel]='Sessions',Sum(Aggr(Visits,VisitFull)) )))...
Leads and Spend giving a Output but Session is Showing 0 ... for Session exp : Sum(Aggr(Visits,VisitFull)) is
Correct because i am getting a proper value without if condition in other chart .. i tried Writing like this as well
um(if([KPI Funnel]='Sessions',(Aggr(Visits,VisitFull)))) ... its giving value but not correct value kindly help me for the same...
>>Sum(Aggr(Visits,VisitFull)) is Correct because i am getting a proper value without if condition in other chart
Your expression looks OK - Sum(If()) is not correct in this context.
What are the dimensions on the table where this expression works?
Why an Aggr()?
Also, I would load the dimension like this:
Load Dual(Text, Order) as "KPI Funnel"
And then used this rather than a nested if:
Sum(Visits), // why do you nee an Aggr??
Hi Jonathan ,
I have a two table from where i am getting an value .. without Aggr i am not getting an proper value..
so i have to use the same.. cant we use aggr in if else...
Aggr expression gives correct output on all dimension say , Date Channel and rest
Hi can anyone please update me on my query
You can try this.