topic Re: Current Slections Straight table showing Duplicate values in QlikView

Current Slections Straight table showing Duplicate values

psankepalli — Wed, 16 Sep 2015 18:05:35 GMT

Hello Experts,

I am using straight table instead of current selections option. My intention is I want to show list of current selections into straight table. somehow few of my dimensions showing twice into the straight table and few other once. I am really not sure what is causing problem.

Here is my Expression

*************************************************

= if(index(vCurrentSelections,only({1}$Field) & ':')>0,

textbetween(concat(TOTAL DISTINCT (OldName & ':'& NewName),'|',OldName ) & '|',only({1}$Field) & ':','|')

)

*************************************************

Here

vCurrentSelections is list of current slections from that sheet.

Old name and new name coming from INLINE table.

$Field= Dimension

Let me know if anyone need more info , so that I can provide.

Thanks

Re: Current Slections Straight table showing Duplicate values

Oleg_Troyansky — Wed, 16 Sep 2015 18:09:57 GMT

It would be easier to troubleshoot if you could post a sample document.

Re: Current Slections Straight table showing Duplicate values

Wed, 16 Sep 2015 22:04:23 GMT

Seems your Only conditions are causing issue. but as Oleg said a sample Doc will always help to understand situation better.

Re: Current Slections Straight table showing Duplicate values

psankepalli — Thu, 17 Sep 2015 13:46:17 GMT

I found the solution, its problem with my logic. next time I will share the sample document. thank you very much for your response.

Expression:

1^st Expression: NewName2

= if(index(vCurrentSelectionsI,'@' & only({1}$Field) & ':')>0,
textbetween(concat(TOTAL DISTINCT (OldName & ':'& NewName),'|',OldName ) & '|',only({1}$Field) & ':','|')
)

This logic has solved my problem.