topic Customizable Straight Table - Using with toggle in QlikView

Customizable Straight Table - Using with toggle

Tue, 12 Apr 2016 20:18:49 GMT

Hello to all,

I have in my dashboard a tab in which I included one customizable straight table. It's working perfectly, but as my dashboard has two languages, I cannot find a way to change the language in my fields.

In attach, there is the model used to build my customizable table.

I'm using a toggle to change the languages in my dashboard and normally I was using a function to change the labels of the fields.

Please find the expression used: '=Text(Only({<Index = {18}>} [$(vLanguage)]))'

vLanguage '=Minstring(#LANGUAGE)' (#LANGUAGE is my language toggle).

I can change the label in my customized table:

But I could not find a way to change the information in my listbox (that is where I filter the values for my table):

After I load my inline, I select the text using the following expression:

The result is that I have a lixbox that looks like the following:

Any thoughts on how to solve this issue? Maybe using some 'trim', 'mid' with a conditional function, but I'm not sure how to do this.

Thanks in advance for your help.

Kind regards,

Marco Arruda

Re: Customizable Straight Table - Using with toggle

swuehl — Tue, 12 Apr 2016 23:08:02 GMT

Sorry, I somehow missed the link between your usage of a language selector and changing the table labels and what you are trying to do with your list box.

By using string functions like right(), trim(), mid() etc., you want to achieve which desired result?

Re: Customizable Straight Table - Using with toggle

sunny_talwar — Wed, 13 Apr 2016 02:24:20 GMT

Would you be able to share a sample or may be elaborate a little more to explain what exactly are you trying to do?

Re: Customizable Straight Table - Using with toggle

Wed, 13 Apr 2016 12:03:46 GMT

Fair enough, I was in a hurry when I wrote this.

Well, starting with the language listbox. I loaded an inline called #LANGUAGE that contains two fields 'portuguese' and 'english'.

I'm using a formula '=Text(Only({<Index = {18}>} [$(vLanguage)]))' in all my listbox labels .

As I said, the vLanguage variable stands for '=Minstring(#LANGUAGE)'.

Regarding my customizable straight table, I'm using the same logic to change the labels of its header:

So, if I choose

I would have

and if I choose

I would have

I would like to apply the same distinction for my straight table:

I use the follow expression as an expression in my listbox (_Dimension).

The main issue is that those names are 'values' in my list box.

Please, let me know if there is still missing points.

I can't send you an sample right now, because of the data that my app has, but if you can't understand I'll build one to show my point.

Thanks a lot folks!

Re: Customizable Straight Table - Using with toggle

sunny_talwar — Wed, 13 Apr 2016 16:20:28 GMT

How do you plan to employ the distinction? This list box or inline is all in portuguese, right? Where is the English version of this inline? Is there one?

Re: Customizable Straight Table - Using with toggle

Thu, 14 Apr 2016 21:02:38 GMT

well, my idea was to use a if statement or something, but I'm not sure the best way.
The idea would be have like in my inline:

01 BPC - Categoria de Despesas / BPC - Expenses Category

So, by the expression

= Right ([_Dimension], Len ([_Dimension])-3) to have some expression that looked in the inline and changed it 'look' up according to the toggle.
That way I could keep all my structure in my dashboard.

Please let me know if you need more information...