Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qvraj123
Contributor II

subfield within set analysis with a constant value

Hi All,

Thanks a lot for your time - I have a text object in which I have the following exression - I need to get use the subfield and also specify the value since this text object is specific to one department

tried the following but it is giving 0 as amount

sum({<Department={"$(=subfield(MAINKEY,'|',1))='SIG PI'"}>} Budget_Amount)

Thanks for your time

Rj

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: subfield within set analysis with a constant value

like this?

sum({<Department={"$(=subfield(MAINKEY,'|',1))",'SIG PI'}>} Budget_Amount)

4 Replies
sasiparupudi1
Honored Contributor III

Re: subfield within set analysis with a constant value

like this?

sum({<Department={"$(=subfield(MAINKEY,'|',1))",'SIG PI'}>} Budget_Amount)

MVP
MVP

Re: subfield within set analysis with a constant value

Post your qvw or a representative sample, otherwise the best you are going to get is guesses, some useful and most not.

Preparing examples for Upload - Reduction and Data Scrambling

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
qvraj123
Contributor II

Re: subfield within set analysis with a constant value

Thank you Sasi


sasiparupudi1
Honored Contributor III

Re: subfield within set analysis with a constant value

You are welcome

Community Browser