topic Re: Fix always minimun selection in QlikView

Fix always minimun selection

inigoelv — Sat, 09 Jan 2016 15:51:16 GMT

Hi everybody:

I have a problem with a complex qlikview that frozen when there is not selection. Excess of calculs.....

My question is to know if it is possible to fix a minimun selection only when I take out all selections, but desappear when I select anyone.

Thanks in advance.

Re: Fix always minimun selection

HirisH_V7 — Sun, 10 Jan 2016 14:00:04 GMT

Hi ,

Please check in your expressions it has no selections.{1<>} Set Analysis
Can you elaborate your requirement.

-Hirish

Re: Fix always minimun selection

settu_periasamy — Sun, 10 Jan 2016 14:30:23 GMT

Are you talking about chart (straight or any other chart)?

May be try to limit using the Getselectedcount() in general tab..like

Getselectedcount(field1)>0 and Getselectedcount(field2)>0

Re: Fix always minimun selection

Kushal_Chawda — Sun, 10 Jan 2016 14:43:11 GMT

You cannot limit the number of selection, But using set analysis you can exclude the selection of Fields from calculation

For example

= sum({<Type={'1'}, Field1=,Field2=>}Sales)

selections from Field1 & Field2 will not affect the calculation or Values will not change. You can include as many field you want to exclude the selection

Re: Fix always minimun selection

sunny_talwar — Sun, 10 Jan 2016 15:52:55 GMT

Can you share a sample with expected output so that we can try to help you better?

Re: Fix always minimun selection

Gysbert_Wassenaar — Sun, 10 Jan 2016 17:28:39 GMT

Add a calculation condition to your chart that checks the possible number of records given the active selections. Something like =if(sum(aggr(1, Dim1, Dim2, ..., DimN))<10000,1,0). Replace Dim1, Dim2, ..., DimN with the names of the dimensions of your chart. Don't forget to add a custom message for the calculation condition too.

You can find an example here: Re: Calculation Condition - Complex

Re: Fix always minimun selection

Sun, 10 Jan 2016 18:15:27 GMT

Could you share a sample document ?