Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using Qlik Sense and trying to come up with a solution for the following:
Create a graph or table (to me this does not matter) based on repeat items in the last 7 days.
What I have is a file that is generated with machines ("Press") "Prob code text, Cause code text, and dates through excel and is uploaded using the Data Load Editor.
What I would like is if the date is = today thru 7days ago and the Press, Prob code text and Cause code text are the same then this is shown.
Is there anyway to code these types of conditions into the graph or table.
Here is some examples:
Example 1 would be shown.
Example 2 the Cause code is not the same - no show
Example 3 the date is more than 7 days apart - no show
Example 4 the Prob code text is not the same - no show
Example 5 the Press is not the same - no show
Example | Malfunct start | Press | Prob code text | Cause code text |
1 | 8/1/2018 | CP088 | Loader | Fitting |
8/5/2018 | CP088 | Loader | Fitting | |
2 | 8/1/2018 | CP122 | Leak - Air | Valve - Solenoid |
8/5/2018 | CP122 | Leak - Air | Air Leak | |
3 | 7/30/2018 | CP089 | Leak - Air | Valve - Solenoid |
8/7/2018 | CP089 | Leak - Air | Valve - Solenoid | |
4 | 8/1/2018 | CP088 | Center Mech | Fitting |
8/5/2018 | CP088 | Loader | Fitting | |
5 | 8/1/2018 | CP069 | Center Mech | Fitting |
8/5/2018 | CP072 | Center Mech | Fitting |
The answer can be found in your other identical question found here: Setting Conditions in Qlik Sense
Please try to follow the community guidelines to not do cross-posting - posting the same question on multiple threads - as this is confusing and might lead to several people answering redunantly and wasting their time on exactly the same question without knowing of each other...