Help to write expression for data comparison

[#1]

Hi All,

I have 3 fields that is not related to one date field.I want to get count of item based on 3 fileds.

Example

I have 3 dates Activated/issued/expired and one separate date field all 3 are not related to date field

Now I have to chk in expression if the dates in activated date = dates in date field then count items activated.

similarly other two.

Can anyone help me with the exptression?

Thank you

Regards,

Prajna

[bbi_mba_76]

Hi,

maybe with something like

count({<[activated date] = p(dates)>} distinct Items)

[#3]

its not working for me

Regards,

prajna

[sujeetsingh]

Alva ,

Please explain the term that how they are not related .

Please explain the table structure .

If possible then give the sample

[#5]

Hi,

I have created a date key using order date/issued date/expired date using below syntax

Load

ItemOrder as DateKey

resident tablename;

concatenate

Load

Item issued as DateKey

resident tablename;

concatenate

Load

Item expired as DateKey

Resident tablename;

Now I want  to display count of item in a  single chart for the 3 dates ordered/issued/expired

how to achieve this?

I need to write expression in my chart dimension chosen is datekey -to represent year-month-week- quarter

Please suggest me the solution

Thank you

Regards,

Prajna

[#6]

Hi,

I would use count() function and a set analysis inside it (as Michele suggested to you)

In the set analysis, I would try to use the concat() function if your dates are similar: one value of one field is also a value of another field.

See an answer at the following thread: http://community.qlik.com/thread/105647

Fabrice