Hi

we still have one Qlikview document with macros that need the use of QlikView IE Plugin. The document is on a Qlikview Server.

We run Qlikview with Microsoft Edge in IE compatible mode. 

In the past, with IE, it was possible to control the use of macros using the key combination Ctrl + shift + m.

This keyboard combination dosn't work with edge in IE mode, so we can't control the macros execution, so at this time we can't execute the document in IE mode.

do you know how yo active the macros in Edge IE compatible mode?

Thanks

Fernando

Hi team,

I have a NPrint report here I applied filters like Product =2, If Product is 2 then will generate the Excel report, If there is no product 2 values in data  in this case empty report generate.

If Product is 2 , NPrint report is generating fine , But there is no values for Product 2 report generation is failed.

Could you please help on that.

Advance thanks

Ram

Hello,

I'm trying to filter lines of a table that has multiple dimensions and only one expression that I use for filtering.

The field's values are something like this:

And the end product has to be something like this: 

I believe that the correct expressión is this one:

Count ( Distinct {<form_order={"max(<[No. Proceso]>form_order)"}>} [No. Proceso])

Do you have any idea why this isn't working?

Thanks!

Hi all, I'm trying to build a word report with a table to meet clients very specific asks around appearance, printing to PDF, etc. I have everything worked out mostly except an indicator and date coloring issues. I've tried color by expression, CSS, formula in Designer and I get some results but not others. I can get the object with color but it isn't aligned properly and the column width expands and there is no border. I have to keep the source formats for the color coding as it is based on a date comparison and as far as I can tell I cannot do that in Word without VBA. If i try to bring over the dates with color i just get a black cell. Any ideas beside using Excel?

Note: it is a Vizlib straight table, the character is chr(11044)

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,
i need to create a multi KPI with a numeric KPI (big font) and a second measure (smaller font).  the second measure says something about the KPI - for exampe that the KPI is above average, below or same as average.  however, the second KPI needs to be colored (green, red, black).

so my second KPI is an expression that returns a text.  my problem is that if i want it colored, i need to use a master measure with segments - however segments can only apply to numeric measures.

something like this:

has anyone done something similar?

thanks

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.