topic Re: hi, community in QlikView

hi, community

Tue, 08 Jul 2014 05:36:31 GMT

i have three columns inwhich id , updatedid, and date is given,

in the id field c it is updated as a , so it should show c as a's respective date , same for f also in my output ,

can u guys pls help me out in this issue, pfa excel of input.

Thnaks in advance.

Re: hi, community

Tue, 08 Jul 2014 05:43:08 GMT

just add a calculated dimension and say

=if (id='c', 'a', if (id='f','b'))

Change the label to

Update ID

if you want to do that in a script just write like this.

load if (id='c', 'a', if (id='f','b')) as [Update ID], *;

load ......................... ;

Re: hi, community

Tue, 08 Jul 2014 05:45:20 GMT

and what if , i want to update more id..,can u pls suggest me without using if

Re: hi, community

jagan — Tue, 08 Jul 2014 05:49:01 GMT

Hi,

Try like this

load

Pick(Match(id, 'c', 'f'), 'a', 'b') AS [Update ID]
FROM DataSource;

If you have more values to compare then add the values in Match and Pick() easily.

Regards,

Jagan.

Re: hi, community

Tue, 08 Jul 2014 05:51:55 GMT

i want to show it in straight chart, so when i click on c so it should show a date as 1/1/2014

Re: hi, community

Anonymous — Tue, 08 Jul 2014 05:54:37 GMT

Hi,

I didn't understand your question exactly. Do you want to show date as per updatedid and if it null/blank than show as per id?

Re: hi, community

Tue, 08 Jul 2014 05:59:10 GMT

when i select c then it should show ,A's date.

id updatedid date

c ---> a 1/1/2014 same for f also , without using if.

Re: hi, community

Anonymous — Tue, 08 Jul 2014 06:19:29 GMT

Hi,

Something like below,

MappingDate:

Mapping

LOAD id,

date

FROM

New Microsoft Office Excel Worksheet.xlsx

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD id,

updatedid,

date,

Date(ApplyMap('MappingDate',updatedid,date)) as updated_date

FROM

New Microsoft Office Excel Worksheet.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: hi, community

jagan — Tue, 08 Jul 2014 06:20:20 GMT

Hi,

Try like this

Temp:

LOAD

id,

Pick(Match(id, 'c', 'f', id), 'a', 'b', id) AS updatedid,

date

INLINE [

id, updatedid, date

a, , 1/1/2014

b, , 2/1/2014

c, a, 3/1/2014

d, , 4/1/2014

e, , 5/1/2014

f, b, 6/1/2014

g, ,

];

NoConcatenate

Data:

LOAD

id,

updatedid,

date,

If(previous(updatedid) = updatedid, Previous(date), date) as updateddate

RESIDENT Temp

ORDER BY updatedid, date;

DROP TABLE Temp;

Regards,

Jagan.

Re: hi, community

Tue, 08 Jul 2014 08:04:15 GMT

hey i jus got confused which diemnsion i have to take , in this and expression also...to create straight chart.

Re: hi, community

Anonymous — Tue, 08 Jul 2014 08:12:58 GMT

Hi,

You have to take "updated_date" as a dimension in your straight table. So that if you select c you will get 1/1/2014 as a date.

Re: hi, community

jagan — Tue, 08 Jul 2014 08:33:06 GMT

Hi Ankit,

Take updateddate as dimension and expressions.

Regards,

Jagan.

Re: hi, community

Tue, 08 Jul 2014 08:38:29 GMT

and what will be the expression for that.

Re: hi, community

Tue, 08 Jul 2014 08:41:34 GMT

tell me and expression also,, i have used ur code Jagan Mohan

and urs too Satyadev Jaiswal

Re: hi, community

jagan — Tue, 08 Jul 2014 08:45:11 GMT

Hi,

Just create one Table box and add the following dimensions

updatedid

updateddate

Regards,

Jagan.

Re: hi, community

Anonymous — Tue, 08 Jul 2014 08:49:37 GMT

Can I know what actually you are trying to achieve here? You may add updated_date as a dimension and id as expression. This will be same as creating table box.

Re: hi, community

Tue, 08 Jul 2014 09:02:38 GMT

thanks frnd, its working now.Jagan Mohan Satyadev Jaiswal