Hello All, please help me in converting below Qlik logic to PBI if someone knows PBI

=count
(
{
<
[Date]={">=$(=AddYears( date(max({< [ State]={'B'}>}[ Date] )),-1))<=$(=AddMonths( date(max({< [ State]={'B'}>}[Date] )),-1))"},
TYPE={'PTS'},
[ State]={'B'}
>
}
DISTINCT [EN Number]
)

Hi People,

I have issue with dates which do not have the same format.

I loaded them as Text, and after exporting them to a CSV file, they still maintain their original format:

Dates in CSV

Exporting to Excel does not have that issue.

Dates in Excel

BTW, If I open the CSV file in Office 365, there is no issue.

Any idea how to resolve it?

Thanks!

Hello! 

I am working on loading a data set looking at patient eligibility for a certain insurance. For this data set, I have a patient ID, start date of eligibility, and stop date of eligibility. See example of data below:

I would like to create a "Yes/No" field in the load script for each patient ID on whether or not they are eligible for the insurance for each month. For example, all the months between 3/1/2022 and 12/31/2022 would say "Yes" for eligibility for patient ID 4, but all the months between 12/31/2022 and 4/1/2023 would say "No" for eligibility for patient ID 4. We thought about using a "For Each" loop, but it seems inefficient given the size of our data set. What would be the best way to achieve this result?

I would like to know how I can find out the username and password for my Postgres database, as my data is out of date in the operations monitor dashboard, and so I cannot know the amount of access to each dasboard we have.

In the beginning, all was simple. I have a graph of Count(Orders) over time.

I have a set of 8 categorical variables that all could be used to filter the data and/or to produce a stacked surface or bar chart, but some have many categories and the chart wouldn't be readable. My goal therefore to highlight only one category of one variable at a time, while still being able to filter on other variables. I thus display two data series: highlighted + rest. This works - but just nearly.

I figured I could use two variables v.HighlightField and v.HighlightValue. The first series would display Count({$<[$(v.HighlightField)]={'$(v.HighlightValue)'}>} Orders), the other one the rest.

I use a first VizLib Variable Input to set v.HighlightField, and a second one to set v.HighlightValue. [If you're curious: it's dynamic values are defined as: Pick(Match(v.HighlightField, '', [Field name 1], [Field name 2], ...), [Value list 1], [Value list 2], ...)]

Now when I set a value of v.HighlightField and a value of v.HighlightValue in the dropdown boxes and subsequently change the v.HighlightField, the value of v.HighlightValue stays as it is. I end up with an incompatible combination of field and value.

How do I clear the latter variable when the former changes? This would do the trick.
Or maybe you know a completely different solution? One big variable with all field names and all values? Meh. Dummy fields to use in the set expression?

Hi Team,

We (Client A for Example) want to carry on an Upgrade for z/OS V2.5 in coming Weeks and QLIK V6.6 is in our System and we are aware that this version is not Compatible with z/OS V2.5.

Now, we would like to know if QLIK V6.6 will be a Show Stopper if we skip this Product's upgrade and perform our z/OS V2.5 Upgrade.

Please Clarify.

Solution for implementing Retry option in Talend. If one of the step failed in talend due to connection error, try this step once again and proceed.

please suggest solution for implementation