topic Re: conditional hide straight table and list boxes in QlikView

conditional hide straight table and list boxes

Anonymous — Tue, 16 Sep 2014 18:05:24 GMT

Hi, I wanted to set a conditional expression to only show straight tables and list boxes let's say if the current selections are for current quarter and weeks range from week 1 thru week 4 of the quarter. ( I have a flag that counts the weeks in the quarter). Also, I am using this on a different state (Alternate states) within the dashboard. Any help is greatly appreciated.

Re: conditional hide straight table and list boxes

JonnyPoole — Tue, 16 Sep 2014 18:18:09 GMT

Here is a sample expression that would check to see if a Quarter(s) and Week(s) were selected and then figure out if the Quarter selected is the current quarter (based on a variable) and the flag for #weeks selected = 4. Your specifics will change a bit but a QVW sample will help give more detailed solutions:

if( getselectedcount(Quarter) > 0 and getselectedcount(week) > 0 and only(Quarter) = $(vCurrentQuarter) and $(vWeekCountFlag) = 4 )

Also, you will need SET ANALYSIS to pull these selections from an Alternate State. The good news is that you can now (just in last few days) download qlikview 11.2 SR8 and leverage alternate states in the getselectedcount() function per the SR8 release note below:

1.3.2 Alternate state parameter for certain functions

New parameter added to the functions “GetSelectedCount()”, “GetFieldSelections()” and

“GetCurrentSelections()” to query other states than the main state.

E.g. =GetFieldSelections(Quantity, ';', ,'StateA')

Re: conditional hide straight table and list boxes

Anonymous — Tue, 16 Sep 2014 18:38:30 GMT

Great! So I just need to download the latest Qlikview and i should be able to apply those field functions?

Thanks!

Re: conditional hide straight table and list boxes

JonnyPoole — Tue, 16 Sep 2014 19:13:33 GMT

Those field functions are in the product now and have been for years, but when Alternate States was introduced 2 years ago, these could not pull the values from the alternate states, only the default state. Now in SR8 they can pull from alternate states... so handy for use case.

Re: conditional hide straight table and list boxes

Anonymous — Tue, 16 Sep 2014 19:48:01 GMT

Thanks, am downloading it now. Will let you know when I get it to work.

Thanks again.

Re: conditional hide straight table and list boxes

Anonymous — Wed, 17 Sep 2014 15:17:06 GMT

Hi, I have downloaded the new SR8 version of qlikview. I added these expressions in "show - conditional" in the layout tab.

if( getselectedcount(Curr_Qtr_Flag) > 0 and getselectedcount(Wk_in_FQ) > 0 and only(Curr_Qtr_Flag) = 'Y' and (Wk_in_FQ) <=4

when i tested this with other quarter, the table is still there....do i need to set up variables? The curr_qtr_flag and wk_in_FQ are both in the back end calendar table that's linked to the main table.

Thanks!

Re: conditional hide straight table and list boxes

JonnyPoole — Wed, 17 Sep 2014 19:09:53 GMT

Do any of these conditions in the IF need to be evaluated off the selections in an alternate state ?

This would be the syntax if needed. This would check if the user has made a selection on the field called [Field] in the alternate state called 'AlternateStateName'.

getselectedcount( [Field],1,'AlternateStateName')

Re: conditional hide straight table and list boxes

Anonymous — Wed, 17 Sep 2014 20:03:37 GMT

if( getselectedcount([Curr_Qtr_Flag],1,'AlternateStateB') > 0 and getselectedcount([Wk_in_FQ],1,'AlternateStateB') > 0 and only(Curr_Qtr_Flag) = 'Y' and (Wk_in_FQ) <=4

does that look right? I have 3 states in the dashboard - inherited, A, and B. I made the above changes but still not working...

Thanks!

Re: conditional hide straight table and list boxes

JonnyPoole — Wed, 17 Sep 2014 20:07:21 GMT

the last condition looks a little strange ( (Wk_in_FQ) <=4) , can you share a QVW example ?

Re: Re: conditional hide straight table and list boxes

Anonymous — Wed, 17 Sep 2014 20:26:08 GMT

Hi, the list boxes at the top of the page is based on State A, and the ones at the bottom of the page are State B. I am trying to apply the conditional hide/show for all the table and list boxes in state B.

Thanks again!

Re: Re: Re: conditional hide straight table and list boxes

JonnyPoole — Thu, 18 Sep 2014 00:19:41 GMT

Hi - i altered the conditional show hide expression to this:

only( {B} Curr_Qtr_Flag) = 'Y' and concat( {B} distinct Wk_in_FQ ,';') = '1;2;3;4'

only( {B} Curr_Qtr_Flag) = 'Y' ---> means that the only possible value for Curr_Qtr_Flg in the current selections for the Alternate State 'B' is 'Y' . Looing at the screenshot below , the Curr_Qtr_Flag list box shows Y as the only value that is green or white so this is TRUE

concat( {B} distinct Wk_in_FQ ,';') = '1;2;3;4' --> Means that the only possible values for Wk_in_FQ in the current selections for the alternate state 'B' is 1,2,3 and 4. The concat() function lists all the possible values with a delimitter. In my case the delimitter is ';'. If i add a distinct it will only list one instance of the value. So below i have selected only 1,2,3, and 4 (green or white) and that means this will evaluate to 1;2;3;4 or TRUE

Re: Re: conditional hide straight table and list boxes

Anonymous — Thu, 18 Sep 2014 15:13:13 GMT

Thank you! That was helpful, and if i need to change the conditions to include other weeks, i'd just need to extend it beyond 4, correct? Also, how'd i hide the list boxes for the curr_qtr_flag and wk in qtr based on the same logic?

Thanks again for your time and help

Re: Re: conditional hide straight table and list boxes

Anonymous — Thu, 18 Sep 2014 15:25:13 GMT

Actually, if let's say user selects week 1-3, the table would be hidden too. I'd like to show the table for week in qtr in the range from 1-4. I tried removing distinct in the expression but it still goes into hidden mode.

Thanks!

Re: conditional hide straight table and list boxes

JonnyPoole — Thu, 18 Sep 2014 15:59:15 GMT

This will work as an updated expression. If they select any combination of 1,2,3, and 4 it will show.

If they select any combination of 1,2,3 and 4 AND a higher wk it will NOT show.

Is that right ? If you want to show it as long as one of the selected weeks is <=4 then switch the 'max' to a 'min' below.

only( {B} Curr_Qtr_Flag) = 'Y'

and

max( Wk_in_FQ) <= 4

Re: conditional hide straight table and list boxes

Anonymous — Fri, 19 Sep 2014 16:25:07 GMT

Thank you!