topic Re: Selections in QlikView

Selections

sunilkumarqv — Wed, 19 Feb 2014 07:59:28 GMT

If i select ID 2 its show only that value

i want it to present 1 and 2

Re: Selections

Sokkorn — Wed, 19 Feb 2014 08:12:57 GMT

Hi Sunil,

Change your expression from Sum(value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value)

Regards,

Sokkorn

Re: Selections

Wed, 19 Feb 2014 08:24:47 GMT

hi sunil,

please find attachment

Re: Selections

MK_QSL — Wed, 19 Feb 2014 08:53:59 GMT

Change your expression as below..

sum({<ID = {'<=$(=Max(ID))'}>}value)

Re: Selections

ashwanin — Wed, 19 Feb 2014 08:57:03 GMT

Change the expression sum (value) to Sum({$<ID ={"<=$(=Max(ID))"}>} value) in the pivot.

You will get the result.

Re: Selections

Wed, 19 Feb 2014 09:04:22 GMT

i think all these all Solutions have Given u desire result

so u can mark this question as answered

Re: Selections

sunilkumarqv — Wed, 19 Feb 2014 09:47:09 GMT

Thanks for valuable contrubution but I link some tricky dynamic MonthendID Dates Please do it that with expression what ever you want

whatever i created dynamically MonthEnID should be used as demension .So here i am getting only related data want it to be all monthends.It work in same manner before what you guys are posted

Re: Selections

MK_QSL — Wed, 19 Feb 2014 09:52:45 GMT

Confused... Can you let us know what is the desired output you want.

Your question is unclear.

Re: Selections

Wed, 19 Feb 2014 10:02:18 GMT

????

Re: Selections

sunilkumarqv — Wed, 19 Feb 2014 10:08:53 GMT

On using dynamic Dates as Dimension in want t od o as of test file

Re: Selections

MK_QSL — Wed, 19 Feb 2014 10:21:27 GMT

Can you prepare your required output in excel or table format?

If you upload the same would be helpful to us to work.

Re: Selections

Wed, 19 Feb 2014 10:41:25 GMT

Hi Sunil,

pls see my attached example. I created a loosen table to control your expressions.

HtH

Roland

Note:

This could be done in a similar way with MothEndID also.

Re: Re: Selections

sunilkumarqv — Wed, 19 Feb 2014 12:03:03 GMT

Please find attached File Can you repuliacate like that