Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

help with exp. calculation

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.

3 Replies
MVP
MVP

Re: help with exp. calculation

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.

See also attached file.

Not sure what you want to say with "and so on..."

Stefan

Not applicable

help with exp. calculation

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.

MVP
MVP

help with exp. calculation

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

Community Browser