Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

gwassenaarswuehlstalwar1

Please look into this issue..

Highlighted
Partner
Partner

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

Is there any solution for this???

Highlighted
Partner
Partner

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

Hi,

stalwar1gwassenaarswuehl

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

Highlighted

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

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

Highlighted
Partner
Partner

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

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)

Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

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

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

Highlighted
Partner
Partner

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

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

Highlighted
Partner
Partner

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

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.