topic Re: help with exp. calculation in QlikView

help with exp. calculation

Mon, 25 Jul 2011 13:04:39 GMT

Hi,

i have the following data:

date| type | v_1| v_2| v_3| v_4|

2011-07-11|0|258 |18 |149 |4344 |0 |

2011-07-11|14|1264 |411 |620 |2492 |0 |

2011-07-11|28|1974 |677 |934 |5564 |0 |

20011-07-11|56|1083 |642 |660 |2037 |409 |

2011-07-25|0|276 |26 |166 |5149 |0 |

2011-07-25|14|1037 |239 |537 |2946 |0 |

2011-07-25|28|1403 |510 |635 |2237 |0 |

2011-07-25|56|2520 |1369 |1292 |3483 |868 |

type 0 on the 11th is type 14 on the 25

how can i display them as a sequence?

something like this..

v_1_type0(2011-07-11) | v_1_type14(2011-07-25)

in the first column i will have the information from the 11th type 0 v_1

in the second column i will have the information from the 25 type 14 v_1

and so on...

I hope i made myself clear.

Thanks in advance.

swuehl — Mon, 25 Jul 2011 13:25:40 GMT

Hi,

the expressions could look like

=only({<date={'2011-07-11'}, type={'0'}>} v_1)

resp.

only({<date={'2011-07-25'}, type={'14'}>} v_1)

This would just compare two values next to each other.

Mon, 25 Jul 2011 13:53:32 GMT

thanks, i will check it out.

"and so on..."

my file is dynamic and is updated on a daily basis,

so it’s not always be 2011-07-11 and 2011-07-25

I will have additional date that need to be compare and checked.

Thanks a lot for your quick replay.

swuehl — Mon, 25 Jul 2011 13:56:15 GMT

Ok, you can replace the literals also with other expression / fields.

Please have a look at Set Analysis in the Help for more details.

Regards,

Stefan