topic Re: Clear all selection clears calculation condition in QlikView

Clear all selection clears calculation condition

Anonymous — Wed, 31 Dec 2014 12:33:22 GMT

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?

Re: Clear all selection clears calculation condition

Wed, 31 Dec 2014 12:51:32 GMT

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

Re: Clear all selection clears calculation condition

Anonymous — Wed, 31 Dec 2014 13:06:29 GMT

do u mean create a new button?

what about the clear button in the tool bar?

Re: Clear all selection clears calculation condition

sunny_talwar — Wed, 31 Dec 2014 13:49:02 GMT

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.

Re: Clear all selection clears calculation condition

Gabriel — Wed, 31 Dec 2014 14:27:45 GMT

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.

Re: Clear all selection clears calculation condition

Wed, 31 Dec 2014 14:47:45 GMT

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.

Re: Clear all selection clears calculation condition

sunny_talwar — Wed, 31 Dec 2014 15:25:46 GMT

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,

Re: Clear all selection clears calculation condition

Wed, 31 Dec 2014 16:24:18 GMT

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.

Re: Clear all selection clears calculation condition

Anonymous — Wed, 31 Dec 2014 16:28:52 GMT

very good ideas

thank you all

Re: Clear all selection clears calculation condition

Anonymous — Thu, 01 Jan 2015 10:13:32 GMT

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

Re: Clear all selection clears calculation condition

sunny_talwar — Mon, 05 Jan 2015 18:02:00 GMT

Hi Nir Katz,

Correct me marioestradarosaif I am wrong, but this is what you were trying to explain (attached qvw).

Best,

Re: Clear all selection clears calculation condition

Mon, 05 Jan 2015 20:02:59 GMT

Hi, did you attached something ?

Re: Clear all selection clears calculation condition

sunny_talwar — Mon, 05 Jan 2015 20:05:35 GMT

Yes I did attach a qvw file. Is it not displaying the file as an attachment?

Best,

Re: Clear all selection clears calculation condition

Mon, 05 Jan 2015 20:57:37 GMT

I guess this is a solution for this problem according to the question.

Re: Clear all selection clears calculation condition

Mon, 05 Jan 2015 20:58:56 GMT

sunindia , brilliant nice job. Also find attached doc and read the initial question.