Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

martin_caruso
New Contributor II

Count of records

Good afternoon, I'm new to the development of Qlik Sense.

I have two problems that are complicating me to solve in a table with the following values:

%CAMPO_CLAVECAMPO_SUM_1CAMPO_SUM_2PORC
4500211977-000109.523.140,009.513.009,00939,00%
4500055052-00030980,00880,008,80%
4500214540-001202.707,802.256,555,00%
4500210678-0006014.024,109.349,402,00%
4500146228-000100,00-5.413,16-1,00%
4500157376-001000,00-1.350,00-1,00%
4500092220-00030950,00--

1) On the one hand, I need to show only records that have values ​​in all their fields. The record for %CAMPO_CLAVE = 4500092220-00030, should not be displayed. In [Add-ons / Data handling /] I have detildada the option of ''Show zero values​​''.


2) On the other hand, it should show in the table only the records where the PORC is greater than 2.00%. As I did not find the option to carry out this action. I decided to show in indicators the number of records where PORC> 2.00% (records in red) and where PORC <2,00% (records in green). The expression I am using is the following, but the result it gives me is the total count to all the records (ie, 7).

Count

  (

  Aggr

          (

          If($(vDif_Porc) > '0,02', 1, 0)

          , [%CAMPO_CLAVE]

          )

  )

I appreciate any help or guidance you can give me about it.

Regards!

4 Replies
ger_alegria
Contributor

Re: Count of records

Hi Martín.

I guess you are working in an table object.

My answer:

1) You have 3 metrics, so if one of the three has value, Qlik show the register.

2) Try with:

if($(vDif_Porc) > 0,02,$(vDif_Porc) )

With that you will show only PORC is greater than 2.00%.

Let me Know more about this

spividori
Valued Contributor

Re: Count of records

Hi.

Review the example below, in my example I show only the years that are> = 70% in Table 2. Hope this help.

Regards.

martin_caruso
New Contributor II

Re: Count of records

Hi Gerardo, first of all I appreciate your response.

Actually, I'm working with a table object.

As for point 1, then there is no way to filter those records that have no value in the FIELD_SUM_2 and PORC fields?

As far as item 2 goes, it still gives me a completely wrong value. My question now is whether there is any conflict with the format of the data. By default, the format is "Auto" but I configured it to be "Numeric" and "12.34%".

Unfortunately for company security issues, I can not pass the original .qvf.

Regards!

martin_caruso
New Contributor II

Re: Count of records

Sandro, thank you for your answer and example but I can not apply it with the value since it contains an expression too complex.

Regards,


Martin.

Community Browser