topic Re: How to add number (variable) along with two different dates in count expression in QlikView

How to add number (variable) along with two different dates in count expression

saivina2920 — Sat, 16 Nov 2024 03:29:51 GMT

How to add number (variable) along with two different dates in count expression.

number variable is dynamic value. it may be 1 to 100 (i.e) 1 to 100 days.

vVariableDays ==> 1 to 100 (days)

if user enter some values, for example "20" then it will add from >=vCalDate & <=vToday + 20 days.

below is my count expression.

=Count({<EmpJoinDate = {"$(='>=' & vCalDate & '<=' & vToday) & '+' & vVariableDays"}>}EmpJoinDate)

The above expression will not give proper count.

How to convert number to days along with two different dates in count expression...?

Re: How to add number (variable) along with two different dates in count expression

chrismarlow — Thu, 23 May 2019 19:53:03 GMT

Hi,

I would pull out the calculated date into another variable, just so I could see better what was going on, then use;

Count({<EmpJoinDate = {">=$(=vCalDate)<=$(=vEndDate)"}>}EmpJoinDate)

Which looks like it works;

Cheers,

Chris.

Re: How to add number (variable) along with two different dates in count expression

saivina2920 — Fri, 24 May 2019 09:35:29 GMT

can you pls. share the .qvw files for reference...?

I am using variables in two places.

1. TextBox and 2. Pie Chart.

1. In the text box, It will show only year, not exact count ==> not working

2. In the Pie chart, i already define the two days. along with i want to pass the variables. (variable already formatted as you given).

How to solve this..?

Herewith i have attached with formula with corresponding fields screenshot and .qvw Files

Re: How to add number (variable) along with two different dates in count expression

chrismarlow — Wed, 29 May 2019 19:41:21 GMT

Hi,

I only have personal edition so I can't open your QVW.

Looking at your screenshots

1) In the text box you don't need $() around the variable - just put =vFinalCountDate

2) I don't understand what you want to show on the pie chart - the count of 2 equals the total on the chart just above - do you want to show # for each of the 2 days 22/5 & 23/5? In which case add NewDate as a dimension?

Cheers,

Chris.