Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sibrulotte
Contributor III

Conditional calculation for expressions

Hi, so I built myself a sandbox.

using this tutorial:

http://livingqlikview.blogspot.ca/2012/01/conditional-dimensions-and-expressions.html

All expressions are built in the pivot I want to show, and I'm using this expression in the conditional calculation of expressions:

 

=

subStringCount(concat(Expr_ID_m,'|'),'A')

Concurrently, I have a table loaded inline table that has two fields:

Expr_m, and Expr_ID_m

A listbox of Expr_m gives me what expression I'd like to show.

It works great. But if there is no selection in thaat field... ALL expressions in the pivot show up.

That is a problem. I initially just made a condition on the pivot to show only if there was at least one selection done on Expr_m.

that works great. But I'm up to a point where I have to many expressions to show in one single listbox, I want to segregate into multiple list boxes.

Expressions for monthly, trimestre, semestre, and YTD.

The work around I found was an extra line in my load inline tables that read EMPTY, with an ID that doesn't match anything, with an automatic selection on these values on sheet activation. THAT IS UGLY.

There must be a better way to limit the expressions shown if I am using multiple listboxes.

I hope I was clear enough. I can't upload my data, but if I get really stuck, I'll try to do a mockup for this forum.

Cheers

1 Solution

Accepted Solutions
sibrulotte
Contributor III

Re: Conditional calculation for expressions

Those were all very helpfull hints thank you. I'm going to mark my answer as the correct as this is what led to the solution;

 

=subStringCount(concat(Expr_ID_m,'|'),'A') and (GetSelectedCount(_expr_m)> 0)

So 2 things:

getselectedcount was for the actual selection, which was done on the field _expr_m

and it has to pass the test >0.

EDIT:

Sean has made a good point: You don't need to test against > 0.

Sorry I can't mark it usefull after the question is marked as answered but that is a very good point.

4 Replies
MVP
MVP

Re: Conditional calculation for expressions

Simon

what about adding an and condition to conditional dimension?

= subStringCount(concat(Expr_ID_m,'|'),'A')  and GetSelectedCount([Expr_ID_m])> 0, 1, 0) 

Regards

Not applicable

Re: Conditional calculation for expressions

Hi Simon,

Massimo's code can be simplified to following.

= subStringCount(concat(Expr_ID_m,'|'),'A')  and GetSelectedCount([Expr_ID_m])

And, this should also work.

=Match('A', $(=Concat(distinct total chr(39)&Expr_ID_m&chr(39), ','))) and GetSelectedCount(Expr_ID_m)

Regards,

Sean

sibrulotte
Contributor III

Re: Conditional calculation for expressions

Those were all very helpfull hints thank you. I'm going to mark my answer as the correct as this is what led to the solution;

 

=subStringCount(concat(Expr_ID_m,'|'),'A') and (GetSelectedCount(_expr_m)> 0)

So 2 things:

getselectedcount was for the actual selection, which was done on the field _expr_m

and it has to pass the test >0.

EDIT:

Sean has made a good point: You don't need to test against > 0.

Sorry I can't mark it usefull after the question is marked as answered but that is a very good point.

Not applicable

Re: Conditional calculation for expressions


You don't need to test the condition.  As long as the GetSelectedCount is not Zero, any number will pass.

Community Browser