Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using functions in set expression

Hi all,

I want to use this formula in a textbox, but it does not show any data. Do you have got an idea?

=concat({<KPI_Category_Name=$(=SubField(concat(KPI_Category_Name,';'),';',1))>} KPI_Name, ',')

I tried the inner formula

=SubField(concat(KPI_Category_Name,';'),';',1)

in a textbox and it gives me the right value.

Thanks for any kind of help!

Regards

1 Solution

Accepted Solutions

Re: Using functions in set expression

See attached qvw.


talk is cheap, supply exceeds demand
13 Replies

Re: Using functions in set expression

Try: concat({<KPI_Category_Name={"$(=SubField(concat(KPI_Category_Name,';'),';',1))"}>} KPI_Name, ',')


talk is cheap, supply exceeds demand
Not applicable

Re: Using functions in set expression

Worked fine, didn't know that combination. Thanks!

Not applicable

Re: Using functions in set expression

I thought I understood it but I actually didn't...

What if I want to use this new value in a set expression?

My try:

=if(maxstring(<{KPI_Name={"$(=subfield(concat({<KPI_Category_Name={"$(=SubField(concat(KPI_Category_Name,';'),';',1))"}>} KPI_Name, ';'),';',1))"}}> Statusname)='green','qmem://<bundled>/BuiltIn/led_g.png','')

Thank you very much!

Not applicable

Re: Using functions in set expression

Hi everyone,

this is my KPI-Name (which totally works in a textbox) :

=subfield(concat({<KPI_Category_Name={"$(=SubField(concat(DISTINCT KPI_Category_Name,';'),';',4))"}>} KPI_Name, ';'),';',1)

I now want to get the Status in this KPI-Name so I need to use it in another Set-Expression which I am not able to create

This has to look like

=maxstring(<{KPI_Name="{$(=subfield(concat({<KPI_Category_Name={"$(=SubField(concat(DISTINCT KPI_Category_Name,';'),';',4))"}>} KPI_Name, ';'),';',1))}"}> Statusname)

... or anything like that but I don't know.

Thanks for any kind of support!

Regards

Not applicable

Re: Using functions in set expression

Doesn't work

Not applicable

Re: Using functions in set expression

HI ,

  Try this below code  small change to your expression .

=maxstring(<{KPI_Name={"$(=subField(concat({<KPI_Category_Name={"$(=SubField(concat(DISTINCT KPI_Category_Name,';'),';',4))"}>} KPI_Name, ';'),';',1))}"}> Statusname)

Regards

Yusuf

Not applicable

Re: Using functions in set expression

hm, this doesn't work and gives the KPI_Name but I need the Statuscolor (like shown before)

thank you for trying.

still got no solution

Not applicable

Re: Using functions in set expression

It says expression OK but doesn't show anything...

Not applicable

Re: Using functions in set expression

Perhaps for that Filter no data is shown .

Can you try using some other value for the Filter(Fields)  in the Expression .

Regards

Yusuf

Community Browser