topic Re: String to be displayed row-wise in straight table in QlikView

String to be displayed row-wise in straight table

ahbzshk07 — Wed, 09 Dec 2015 11:19:44 GMT

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

Re: String to be displayed row-wise in straight table

Gysbert_Wassenaar — Sat, 12 Dec 2015 13:27:42 GMT

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.

Re: String to be displayed row-wise in straight table

ahbzshk07 — Mon, 14 Dec 2015 10:52:19 GMT

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