Qlik Community

Qlik Sense App Development

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

kavita25
Valued Contributor

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

8 Replies
kavita25
Valued Contributor

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

gwassenaarswuehlstalwar1

Please look into this issue..

kavita25
Valued Contributor

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

Is there any solution for this???

kavita25
Valued Contributor

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

Hi,

stalwar1gwassenaarswuehl

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

MVP
MVP

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

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

kavita25
Valued Contributor

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)

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
kavita25
Valued Contributor

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

karthiksrqv
Contributor II

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