Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want to hide this expression from master Item... It should show only State as a label not the whole expression...
Aggr(If(Sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>}[Dealer Outstanding]) <> 0,State),State)
I want to show bottom 5
Drill down Dimension :
State-> Area-> Location -> Dealer created in master item.. with the above expression..
Expression in Chart :
If(Rank(-(sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>} [Dealer Outstanding])/100000
)) <= [_Top/Bot],
(sum({<Link_Date={'>=$(vCalMinDate)<=$(vCalCurrentDate)'}>} [Dealer Outstanding])/100000
))
Regards,
Kavita
Please look into this issue..
Is there any solution for this???
Have not worked on Qlik Sense to know the answer for this. Sorry
Okay..
But can I change the logic or something so that it wont show the whole expression on dimension rather than the actual dimension like (State,Location)
Please post a small Qlik Sense document that demonstrates the problem.
Hi gwassenaar,
PFA where my problem is I want to show bottom 5 (excluding 0 values in chart as per the dimension i.e drill down).
I have done that using calculated expression in master item... but it is visible in chart...I want to show only the dimension name instead of whole expression using drill down in qlik sense
Regards,
Kavita
Hi Kavita,
One way you can achieve it is by putting each of the 3 fields that make up your drill-down into variables. Then, use the variables in the drill-down.
Example
=$(v_dealer_state)
in your Drill-down with
"v_dealer_state" storing
Aggr(If(Sum([Dealer Outstanding]) <> 0,State),State)
While this should be the solution for now. I also noticed a behavior that could point to a bug. Just take Aggr(If(Sum([Dealer Outstanding]) <> 0,State),State) and add a single-field master dimension and name it "State". Then magically, even your drill-down "Drill" seems to show "State".
1. Create new table in script with this code at the end of reload:
//Iterate through the loaded tables
For t = 0 to NoOfTables() - 1
//Iterate through the fields of table
For f = 1 to NoOfFields(TableName($(t)))
AppTables:
Load
TableName($(t)) as Table,
TableNumber(TableName($(t))) as TableNo,
NoOfRows(TableName($(t))) as TableRows,
FieldName($(f),TableName($(t))) as Field,
FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo
Autogenerate 1;
Next f
Next t;
t = Null();
f = Null();
2. In table, use calculation condition foe fields like this:
Count({<Field = {'SegmentsCount_inDate'}>}Field) > 0
This solution prevent errors if field doesn't exists after reload.