topic Re: Not able to deselect a calculated dimension in Table in QlikView

Not able to deselect a calculated dimension in Table

chhavi376 — Wed, 06 Dec 2017 06:11:53 GMT

Hi all,

I have a straight table in one of my dimensions is calculated. something like - if(isnull(col1),col2,col1)

if i am selecting a value from this dimension, the table shrinks and only that row is returned.

if i want to deselect it by clicking on it again to get the whole table again i am not able to do so.

Please help me with it.

Regards,

Chhavi

Re: Not able to deselect a calculated dimension in Table

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:16:58 GMT

What is the question here? You said filter done and it associates to the same when you filter out all data come up. Off course, Qlik is associate engine as we aware.

Re: Not able to deselect a calculated dimension in Table

chhavi376 — Wed, 06 Dec 2017 06:18:24 GMT

My question is that i when i click on that calculated dimension again, i cant get the table back.. Ideally the selection should get removed when i click on it again

Re: Not able to deselect a calculated dimension in Table

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:21:10 GMT

Could be you are clicking with different row. Can you check the single value where it covers and use same expression in filter like list box as expression. then look which is filtered and same cross check in straight table for unit.

Re: Not able to deselect a calculated dimension in Table

chhavi376 — Wed, 06 Dec 2017 06:39:54 GMT

If i click on a value belonging to col1, some values from col2 are also selected at the same time.

and as i click on only 1 value of col1, col2 values are still selected and the table remains as it is.

col2 values appear to be selected in background as they don appear in the table. how can this be handled?-- the col2 values also get deselected as i deselect the first col values?

Re: Not able to deselect a calculated dimension in Table

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:47:30 GMT

that is because your calculate dimension covers col1 and col2 at a time in single cell.. For assumption you may try with 2 calculated dimensions and one measure as yours

If(IsNull(col1), col1)

If(IsNulll(col2), col2)

// Note, suppress should be enable and start test how this is?

Re: Not able to deselect a calculated dimension in Table

chhavi376 — Wed, 06 Dec 2017 06:49:50 GMT

But i want both the values in one column only

Re: Not able to deselect a calculated dimension in Table

Anil_Babu_Samineni — Wed, 06 Dec 2017 06:57:23 GMT

Off course, If customer request in single that means we never change business. For testing, We can play anything. Because with out accessing it has occurring other case which linked up to the each dimension until unless non grouped.

Re: Not able to deselect a calculated dimension in Table

avinashelite — Wed, 06 Dec 2017 06:59:25 GMT

derive this column in the script level ...that will solve your issue ..in front end it will be the same behavior...