Stack Overflow
Stack Overflow

Questions tagged [qlik-expression]

Qlik expressions are defined in the Expression Editor.

96 questions
0
votes
1 answer

Selection Issue

So I have this QVD where records seize to update incrementally, the last record is dated 25/04/2022. However, I enable to generate new dates to calculate the interest accrued with the expression; RANGESUM(BELOW(SUM(DailyInterest),0,NOOFROWS())) +…
LoKi_Asterix
  • 7
  • 3
0
votes
1 answer

QlikView - Force table box to not show data if date range in calendar object is data empty

i have a calendar object that uses a master calendar as base. All the data is shown on a table box and this data is based on the date range selected on the calendar object. My data does not have values for all the date range but only for some…
RafaOliver
  • 3
  • 1
0
votes
1 answer

Find the third field if two fields have non zero values

My dataset - A B C abc 0 12 ert 0 45 ghj 14 0 kli 56 78 qas 0 0 I want to find the values of A for which values of B and C together are non-zero. Expected output- A B C kli 56 78 I…
Code_ninja
  • 117
  • 1
  • 10
0
votes
0 answers

How to count occurrence of different features on a category in Qliksense and output a bar graph?

I am quite new to Qlik and I am trying to make a measure that counts different categories for outputing a bar graph with the count of each category on said graph. Anyone know how to do this? Right now I am processing the raw data on Alteryx to…
tiagoeng
  • 1
0
votes
1 answer

How to let user select columns to be displayed in table on Qliksense?

I have a table with a large number of columns so I would like to have a filterpane/listbox with all the dimensions and measures allowing the user to select the columns they would like to see in the table. My table looks like this where the columns…
user42
  • 871
  • 1
  • 10
  • 28
0
votes
1 answer

How to display/populate a table only based on selection table in Qliksense?

I have two tables: They are linked by CustomerId. Currently, I display both the tables on a sheet in Qlik and on selection of the CustomerId in the first table, the values in the second table are updated. However I would like to start with an empty…
user42
  • 871
  • 1
  • 10
  • 28
0
votes
1 answer

How to select values in one table based on variable from another table in QlikSense?

I have two tables, They are linked by CustomerID. I have created a variable input Sales = StoreSales and I want to display a table with the relative frequency of the occurence of the stores based on the variable Sales. So suppose I have selected…
user42
  • 871
  • 1
  • 10
  • 28
0
votes
1 answer

How to create a range picker for a variable in Qlik?

I'm new to Qliksense and I would like to select and visualise all datapoints in my table based on the value of a variable called NoOfPersons, similar to the date-range picker. How can I do this? I have attached a sample image below:
user42
  • 871
  • 1
  • 10
  • 28
0
votes
1 answer

Script not working with STARTS WITH function in Qlik Sense

I'm trying to load some tables using the script, in order to create new tables according to an IF condition. My script is the following: LOAD Pippo if(color = 'green', 'ok', if(color = 'yellow' and text <> 'No control needed', 'check', if(color =…
Mr Light
  • 129
  • 13
0
votes
1 answer

Use joined column for further calculations after Join in Qlik Sense

I am going to create a dashbord for our self activities and therefore have joined two fact tables. Now, i want to make further calculations with the new columne but QlikSense shows an error and indiacted that the columne "DeliveredQuantity" couldn't…
user17159356
0
votes
1 answer

Rounding up text in Qlikview

I am trying to round up the outcome of the text below. I know the € #.##0 probably needs to be placed at the ends, but I can not get it to work icw to the brackets etc. Thank you in advance. =if(SUM(EM)>= 400000,…
Olivetree202
  • 7
  • 4
0
votes
1 answer

Qlikview rounding up expression

I am using the following expression in Qlikview: =Num((if(SUM(EF)>= 100, num((((SUM(EF)-100)*0.0118)+12000), num(SUM(EF)*0,03,))))) I want to round the number. Like '€ #.##0'. How/where do I insert this into the expression? Can't seem to get it to…
Olivetree202
  • 7
  • 4
0
votes
2 answers

How do i convert a .dat file to .zip in qliksense

I am new to QlikSense, and I want a file to be converted into zip format. For Ex. File .dat file present at location C:/MyLocation/ABC.dat is expected to get converted into C:/MyLocation/ABC.zip. kindly help with the solution Thanks
Aieshwaryathakur
  • 1
  • 3
0
votes
2 answers

Get values WHERE account number has patterns in SQL or Qlik view

I'm new to Qlik view and want to write a query to retrieve records with specific pattern. I have Account Table which has accountNo field and the values of the field are in the following patterns…
Mike Eale
  • 101
  • 1
  • 9
0
votes
1 answer

Qlik -create calculated Dimension to show barchart from month start untill filter date(5-4-4 calendar)

I have a master calendar(5-4-4) that look like the below image. I have a Date column in the Sales table. I'm using that Date column in the Selection pane(Filter). Example Scenario: now I selected Selection pane date '15-10-2020', bar-chart only…
UDAYA KUMAR R
  • 11
  • 3
1 2 3
4
5 6 7