...eletion flags while still maintaining an incremental load approach. Kindly help with below script IF Len('$(QVD_PATH)') = 0 THEN
Final:
SQL SELECT
A.ID,
A.NAME,
B.RATE,
A...
Table: Load * inline [ ID, Type 1, A 1, B 2, A 2, B 2, E 3, D 3, B 3, C ]; FlagTable: LOAD ID, 1 as Flag1, IF(MATCH(UPPER(Type), 'A'), 1) as Flag2, &n...
...o create a flag of some sort to be able to count totals of the code type either by ID or overall. For example: ID 1 I would want a total of $250 for red, $120 for green and $50 for blue. Overall, I...
Hi all, Quite new to Qlik so bear with me if this is an easy one. I have data that looks like this: Unique ID Customer Region Attribute 1 Attribute 2 Attribute 3 Flag 1 Flag 2 Flag 3...
...he Observations table holds up to 3 records per %KEY_CARS. I need to set a flag for each patient / record within the master table where the patient recived a 'care bundle'. For example &n...
...odel so I am using this code it woks on just on field but on multiple field concatenate
=if(count(total <ID&Tradedate&Tranno>ID&Tradedate&Tranno)> 1,'D...
...bsp; I originally had 2 seperate flags, but wanted to combine the logic into 1 new one ( for easier charting - I couldn't get the set analysis to work to display the results of both in the same chart e...
Hi There,
I want to create a new flag field whenever the term below terms are found in Name or Desc columns.
CD or Disc or CD Disc
ID
Name
Desc
Pos
6957
GBC P...
Hello,
Fiscal Year start is : Oct 1 and ends : Sept 30
Requirement is need to flag all dates that is within Sept 30 - Oct 1 regardless of year.
If there is a 9/3...
Hi, I am building a report and just trying to get my set expression correct. I have created multipleflags, BBNIFLAG01,02,03 is what generates the report from the QVD. I need to create a report w...
