Still I am bit unclear whow to perform it. Actually, my real data set is a large and bit complex than what i have posted (simply because of the clarity). In the said data set, I have got number of Flags for different requirements and finally want to retrieve the data where the Flag values are "1".
Let me explain my requirement. using the same data set i have used above,
Consider the below table,
Assume, I want to retrieve the data where the country is equal to "NZ" (Flag1) and the Quantity is greater than 15 (Flag2).
Thus, once I load the data in to Qlik Sense it will load all 8 records to the Temp Table I have created. However, if i want to visualise the data (using the Table property in qlik sense) I need to see only the filtered data (Country = NZ and Quantity >15). Effectively the data I want to use for the visualization should be something like below,
( Resultant Table)
Using the data load editor, I can load all the data to Qlik Sense.
If(Country = 'NZ', 1 , 0) as Flag1,
If(Quantity>15,1,0) as Flag2
FROM (Data Source connection);
Could anyone help me with the subsequent steps with the things I need to do in order to reach at the final stage of "Resultant Table"
Since the flags are already created to filter the required data, I want to use the said flag to develop the final table which is, "Resultant Table".
Appreciate a lot, if you could provide the answer in a step by step approach for me to implement in my real data set without any issue.
(Something do with expressions like "If(Flag1=1..... and If(Flag2=1,......., etc)
Could anyone please help me to resolve the below issue.
Trying till yesterday but still couldn't fixed it. Table 1 depicts the entire data set that I have loaded to Qlik Sense app. My objective is to filter the data which only fulfills the Flag value of "1".
I wrote the below mentioned expression on the data visualization view.
Expression I used is, "Count(If(Flag1=1,1,0))"
However, when i run the expression I am getting an error as shown below,
I am bit surprised to see the "Invalid Dimension" error message as shown above. I could have used a single flag to accomplish both the conditions (Country = 'NZ' and Quantity >15).
I have used only a single filter above (only the Flag1). A similar approach will take to Flag2 upon successfully resolving the above issue.
Appreciate if anyone could help me to resolve the above mentioned issue as soon as possible.