topic Re: back ground color expression in QlikView

back ground color expression

ssriramin19 — Fri, 28 Aug 2015 04:37:39 GMT

I have a requirement in which date range should be colored from current month till december 2015. So I have used the condition

=IF(YearMthDate>=today(),Yellow()) in the expression back ground . But there is a field called dp_lag which has values 0,1,2.3 .When I select any values in the field dp_lag the color range is not appearing in the dp_field

what should be done to make the color range appear always irrespective of selections in the field?The color range for the given month should not change

Please provide some approach on this.

Thanks

Sriram

Re: back ground color expression

tresB — Fri, 28 Aug 2015 04:45:37 GMT

You have to use set analysis {1} in the expression. Try to share a sample qvw so that it can be shown at your context.

Re: back ground color expression

ssriramin19 — Fri, 28 Aug 2015 05:01:54 GMT

The expression : =num(Sum({<[LAG]=>}distinct([dmd_plng_qty_summary])),'0' ) & Sum({<[LAG]=,[LAG_DP]=>}DISTINCT [dmd_plng_qty_current])

the back ground color expression for the above mentioned expression is :

IF(YearMthDate>=today(),Yellow())

The future date expression in the above mentioned set analysis expression corresponds to :

Sum({<[LAG]=,[LAG_DP]=>}DISTINCT [dmd_plng_qty_current])

So the future range from august to december 2015 is colored using the expression :

IF(YearMthDate>=today(),Yellow())

Please help me on this

Re: back ground color expression

ssriramin19 — Fri, 28 Aug 2015 05:14:02 GMT

can anyone provide me on how to approach the given problem .

Re: back ground color expression

tresB — Fri, 28 Aug 2015 05:33:06 GMT

What is there in dimension? Could you not share a sample?

Re: back ground color expression

ssriramin19 — Fri, 28 Aug 2015 05:34:21 GMT

in dimension it is mnthname and division code .There are two dimensions

Re: back ground color expression

qlikviewwizard — Fri, 28 Aug 2015 05:46:21 GMT

Hi,Please attach the sample application.

Re: back ground color expression

ssriramin19 — Fri, 28 Aug 2015 05:59:19 GMT

since the size of the application is large I am finding difficult to upload the qvw file here