Clear all selection clears calculation condition

[Anonymous]

hi all,

i have a table with data, that the user can dynamically  add or remove columns & measures, (see picture)

how can i auto select minimum column & measure so the table will not dissappear each time the user clears the selection?

[#2]

Hi,

Use a button For Clear All with the below actions in the same order as mentioned here.

1. Clear All action

2. Select In Field Action  ---> specify any one default value from Columns

3. Select In Field Action  ---> specify any one default value from Measures

Hope it helps you.

--- Ravi

[Anonymous]

do u mean create a new button?

what about the clear button in the tool bar?

[sunny_talwar]

If I understand your question, you may be able to achieve what you are trying to do by using the 'Set Clear State'. You can use 'Set Clear State' to define what exactly you want to select/deselect when you click on the Clear button.

For example if you want that every time user clicks on the clear button the default should be a selection on Advertiser name from the Column list box and Total View from measure list box. Then select those two from the two list boxes and click on 'Set Clear State'. Once that is done, every time somebody click on Clear button, the default will be Advertiser name and Total View from those two list boxes.

PFA the image to locate 'Set Clear State'

I hope this would be helpful.

[Gabriel]

Hi,

Alternate State is good feature in qlikview is good however it has it cost.

What I think you can do is to have a button to clear and set a default selection. Using Ravi Kumar's suggestions.

Best Regards,

Gabriel.

[#6]

Why don't remove the Conditional statement for the one Dimension and one expression you nee to have by default in the Table?. that way these two columns won't be affected by the dynamic table creation.

[sunny_talwar]

Mario,

That is a def. a smart way to do it. But thinking out loud, lets say user comes in and want to see another expression and dimension (and want to remove the default expression and dimension), they won't be able to do that based on a list box selection (Since they are not conditional on list box selection anymore), right?

Best,

S

[#8]

In the condition of default ones you can say

in the dimension that's supposed to be default

IF ((GetSelectedCount(MyPickListDimension) = 0 OR yourCURRENTCONDITION , -1 , 0)

and in the expression that is supposed to be default

IF ((GetSelectedCount(MyPickListExpression) = 0 OR yourCurrentCONDITION , -1,0)

replace -1 and 0 to your current True() or False() or condition you use.

BOTTOM line is that in the case the user hasn't selected anything they should be visible

in the case the use has selected something and deselects the current dimension or expression then it should return false according to yourcurrentcondition.

🙂 more or less play around with it.

[Anonymous]

very good ideas

thank you all

[Anonymous]

hi Mario,

please let me understand better you thoughts,

are you saying that when using your suggested condition,

if the user will clear "all selection", the dimension & expression table will not be effected?

since it will use the former selection?

if so, this is an outstanding solution

could you please elaborate on implementing it?

thanks in aadvance