Top "Qlikview" questions

Counting unique values in a column in pandas dataframe like in Qlik?

If I have a table like this: df = pd.DataFrame({ 'hID': [101, 102, 103, 101, 102, 104, 105, 101], 'dID': [10, 11, 12, 10, 11, 10, 12, 10], 'uID': ['James', 'Henry', 'Abe', 'James', 'Henry', 'Brian', 'Claude', …

python pandas numpy qlikview qliksense

Limit dimension values displayed in QlikView Pivot Table Chart

I have a pivot table chart in QlikView that has a dimension and an expression. The dimension is a column …

qlikview

QlikView - Use a variable into set analysis expression

I've the variable varCurrentYear varCurrentYear = Year(Today()) And I wrote this set analysis expression The result it’s not correct. …

variables set analysis qlikview

How to add a set of values that lies between two start date and end date

I have created two dropdown list 1. start date 2. end date I am using MySQL database as a source and I …

qlikview reporting-tools

PHP PDO ODBC connection

we are trying to create a connection with our SQL database trough ODBC in PHP. This is our current script: $…

php pdo odbc qlikview

Qlikview, how to create an expression which does not change with listbox selection?

Example, I have table below.. Week, Quantity 1, 10 1, 15 1, 10 2, 20 2, 30 3, 10 3, 50 I also have a list box for 'Week' which is current selected on …

expression qlikview

Handling multiple fact tables in Qlikview

I have a PostgreSQL database containing various education data such school-level test scores and enrollment figures. I need to separate …

database database-design data-warehouse qlikview dimensional-modeling

Creating variable during load script in Qlikview

I am trying to set a variable in my load script using a previous loaded table, for example: Data: load * …

qlikview

Qlikview - calculate and use calculated variable in script

As a new Qlikview user, I'm looking for the best way to create calculated variables, and variables based on calculated …

sql qlikview calculated-field

Storing multiple tables into a QVD in QlikView

Is it possible to store more than one table's data into a single QVD document? If so, how can I …

qlikview