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_CLAVE
CAMPO_SUM_1
CAMPO_SUM_2
PORC
4500211977-00010
9.523.140,00
9.513.009,00
939,00%
4500055052-00030
980,00
880,00
8,80%
4500214540-00120
2.707,80
2.256,55
5,00%
4500210678-00060
14.024,10
9.349,40
2,00%
4500146228-00010
0,00
-5.413,16
-1,00%
4500157376-00100
0,00
-1.350,00
-1,00%
4500092220-00030
950,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.
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.
