topic Re: Help to write expression for data comparison in QlikView

Help to write expression for data comparison

Wed, 29 Jan 2014 08:25:43 GMT

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

Re: Help to write expression for data comparison

bbi_mba_76 — Wed, 29 Jan 2014 08:30:51 GMT

Hi,

maybe with something like

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

Re: Help to write expression for data comparison

Wed, 29 Jan 2014 08:47:11 GMT

its not working for me

Regards,

prajna

Re: Help to write expression for data comparison

sujeetsingh — Wed, 29 Jan 2014 08:57:37 GMT

Alva ,

Please explain the term that how they are not related .

Please explain the table structure .

If possible then give the sample

Re: Help to write expression for data comparison

Wed, 29 Jan 2014 09:03:17 GMT

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

Re: Help to write expression for data comparison

Wed, 29 Jan 2014 09:12:05 GMT

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