topic Re: How do I get the value of a variable given another defined variable? in QlikView

How do I get the value of a variable given another defined variable?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm trying to make a text box where I can do something along these lines.

=Count({<Status={'In Production'}>} Status)

The problem is that the number should come out to being about 4,000 but it's only coming out to 3.

When I make a multi box, I can select the "ITMS Type", "Status" (which is In Production), and then I can get a count of those two combined variables because I sent a count command using SQL.

What I want is the count of all ITMS Types with the Status of "In Production". How do I go about doing that?

Re: How do I get the value of a variable given another defined variable?

Gysbert_Wassenaar — Tue, 29 Nov 2016 12:41:41 GMT

Try counting [ITMS Type] values instead of Status: =Count({<Status={'In Production'}>} [ITMS Type])

Re: How do I get the value of a variable given another defined variable?

lironbaram — Tue, 29 Nov 2016 12:42:21 GMT

maybe something like this

sum(aggr(Count({<Status={'In Production'}>} Status),["ITMS Type]))

Re: How do I get the value of a variable given another defined variable?

sunny_talwar — Tue, 29 Nov 2016 12:44:24 GMT

Would you be able to share a sample to show the issue you are facing?

Re: How do I get the value of a variable given another defined variable?

Tue, 29 Nov 2016 12:48:22 GMT

I worked around it by using SQL code "SQL SELECT * FROM db WHERE db.tbl.[Application Status] = 'In Production'"

After that I did "=Sum([Count of ITMS Type])" in the Text field of the Text Object.

Problem solved.