QlikView App Dev

[ahbzshk07]

Hi!

I am getting one issue on dashboard for straight table.

My variable vCurrrentSelections = Jahr:2015|Monat:Dec

and I am using $(Field) for dimension in Straigh table
and
=textbetween('|'&vCurrentSelections ,  only({1}$Field) & '|' ,  ':') for 1st expression
so as to get Jahr followed by Monat row-wise... But this is not working.

Though the 2nd expression
=textbetween(vCurrentSelections&'|' ,  only({1}$Field) & ':' ,  '|') is giving 2015 followed by Dec row-wise correctly.

Do you know what may be the problem?

Ultimately, the string 'Jahr:2015|Monat:Dec' should be displayed as

Jahr	2015
Monat	Dec

If there's any alternative for the expression part, then do let me know.

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try these:

Dimension =valueloop(0,Substringcount(vCurrentSelections,'|')

1st expression: subfield(subfield(vCurrentSelections,'|',rowno()),':',1)

2st expression: trim(subfield(subfield(vCurrentSelections,'|',rowno()),':',2))

You can hide the dimension on the presentation tab.

[ahbzshk07]

That was perfect... Thanks for your help...