Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

How to hide expression calculation...in master item..

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

9 Replies
kavita25
Partner - Specialist
Partner - Specialist
Author

gwassenaarswuehlstalwar1

Please look into this issue..

kavita25
Partner - Specialist
Partner - Specialist
Author

Is there any solution for this???

kavita25
Partner - Specialist
Partner - Specialist
Author

Hi,

stalwar1gwassenaarswuehl

Can u please suggest me the solution or any idea..to solve it...

sunny_talwar

Have not worked on Qlik Sense to know the answer for this. Sorry

kavita25
Partner - Specialist
Partner - Specialist
Author

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)

Gysbert_Wassenaar

Please post a small Qlik Sense document that demonstrates the problem.


talk is cheap, supply exceeds demand
kavita25
Partner - Specialist
Partner - Specialist
Author

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

karthiksrqv
Partner - Creator II
Partner - Creator II

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

stantrolav
Partner - Creator II
Partner - Creator II

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.