topic Help with when to display data in QlikView

Help with when to display data

hopkinsc — Fri, 16 Jul 2010 11:01:21 GMT

Hi,

i have a straight table that i only want to populate with results when selections have been made from my selection criteria.

Here is an explanation of what i am trying to do...

I have a RETAILER SELECTION where the user selects 1 or more selections i,e. RETAILER NAME, REGIONAL MANAGER, SOFTWARE VERSION, CUSTOMER TYPE etc

Once at least 1 selections have been made, my STRAIGHT TABLE populates with various retailer information.

I only want the straight table to populate AFTER a selection has been made. So until a selection is made, the straight table will be blank.

Is this easy to do?

Thanks for your help..

Help with when to display data

Fri, 16 Jul 2010 11:10:49 GMT

Here you can do it.

General tab

Calculation Condition.

Anders

Help with when to display data

hopkinsc — Fri, 16 Jul 2010 11:13:50 GMT

Thanks, But what condition would i type?

Help with when to display data

Fri, 16 Jul 2010 11:24:29 GMT

I have done it when one have to select only one country.

count

Maybe that can help you

Anders

(distinct(COUNTRYNAME)) = 1

Help with when to display data

hopkinsc — Fri, 16 Jul 2010 11:50:18 GMT

Hi again,

That worked, but if i select more than one of the retailer options, it hides all results.

I want it to show results if 1 OR MORE selections have been made, not show results if only 1 selection have been made.

Any ideas?

I have tries using <=0 but with no luck..

Help with when to display data

Fri, 16 Jul 2010 11:50:49 GMT

I think you should write this as Condition:

Count(distinct RETAILER NAME )>= 1
Or Count(distinct REGIONAL MANAGER) >= 1
Or Count(ditinct SOFTWARE VERSION) >= 1

I hope it helps.

Regards,

Miha

Help with when to display data

Mon, 19 Jul 2010 14:37:39 GMT

You should actually try this way:

not

And not IsNull(GetFieldSelections(REGIONAL MANAGER,','))

...

This is a better way, because the previous version did not work if nothing was selected...

Regards,

Miha

IsNull(GetFieldSelections(RETAILER NAME,','))

Help with when to display data

Mon, 19 Jul 2010 14:39:49 GMT

the previous post is messed up, so once again (hope it will be better now ;):

not IsNull(GetFieldSelections(REGIONAL MANAGER,',')) And not IsNull(GetFieldSelections(RETAILER NAME,','))