topic Re: How to hide expression calculation...in master item.. in App Development

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

kavita25 — Wed, 08 Mar 2017 05:07:19 GMT

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

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

kavita25 — Wed, 08 Mar 2017 09:38:15 GMT

gwassenaar‌ swuehl‌ stalwar1‌

Please look into this issue..

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

kavita25 — Thu, 09 Mar 2017 07:14:05 GMT

Is there any solution for this???

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

kavita25 — Thu, 09 Mar 2017 12:08:22 GMT

Hi,

stalwar1‌gwassenaar‌ swuehl‌

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

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

sunny_talwar — Thu, 09 Mar 2017 12:11:45 GMT

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

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

kavita25 — Thu, 09 Mar 2017 12:15:13 GMT

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)

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

Gysbert_Wassenaar — Thu, 09 Mar 2017 16:39:01 GMT

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

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

kavita25 — Fri, 10 Mar 2017 06:29:07 GMT

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

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

karthiksrqv — Fri, 10 Mar 2017 08:58:31 GMT

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

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

stantrolav — Mon, 05 Aug 2019 12:12:33 GMT

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.