topic Re: Qlikview display Problem in QlikView

Qlikview display Problem

Thu, 25 Sep 2014 14:09:12 GMT

hello , i want to stop displaying the fourth semestre for 2014, but keep it for 2013
please i need your help

Re: Qlikview display Problem

maxgro — Thu, 25 Sep 2014 14:20:24 GMT

maybe using an expression in listbox

=aggr(only(if(y=2014 and q=4, null(), q)), q)

replace y and q with your year and ...

Re: Qlikview display Problem

MarcoWedel — Thu, 25 Sep 2014 15:15:22 GMT

Hi,

one solution might be:

hope this helps

regards

Marco

Re: Qlikview display Problem

Thu, 25 Sep 2014 16:22:37 GMT

thank you Marco ,

i don't want to display two listbox in the same time , i don't know if we can make a kind of dynamic list box, once we select 2014,the fourth quarter disapear and when we select 2013 it reappear again ??

Re: Qlikview display Problem

MarcoWedel — Thu, 25 Sep 2014 17:08:16 GMT

I only meant to show the right list box using the expression that hides the T4 value when 2014 is selected

Re: Qlikview display Problem

maxgro — Thu, 25 Sep 2014 19:35:49 GMT

=aggr(only(if(Annèe=2014 and Trimestre='T4', null(), Trimestre)), Trimestre)

Re: Qlikview display Problem

jaimeaguilar — Thu, 25 Sep 2014 19:38:14 GMT

Hi,

the easy way to just hide T4 from 2014 is to activate "Hide excluded" in properties, so depending on selections you will only see possible values like this:

regards

Re: Re: Qlikview display Problem

MarcoWedel — Thu, 25 Sep 2014 22:20:31 GMT

to clarify:

hope this helps

regards

Marco

Re: Qlikview display Problem

stevedark — Thu, 25 Sep 2014 22:35:42 GMT

Just to point out, that the thread title suggests there is a problem - but actually having values displaying in the Grey area of listboxes is actually one of the most effortlessly useful features of QlikView!

Just taking the example of years and quarters, as soon as you select 2014 you are reminded (by the grey) that we are not yet in the fourth quarter.

The more you can embrace this rather than trying to work around it then better your QlikView experience will be.

Just my two pennies worth.

Steve

Re: Qlikview display Problem

jaimeaguilar — Thu, 25 Sep 2014 22:42:16 GMT

Yes, that is exactly the point, even when you can hide values, if you do that, you will be missing the power of green, gray and white,

regards

Re: Qlikview display Problem

Sat, 27 Sep 2014 14:58:37 GMT

thank you guys for your answers, that's was really helping

Re: Qlikview display Problem

MarcoWedel — Sat, 27 Sep 2014 16:32:29 GMT

please close this thread, if your question is answered.

thanks

regards

Marco