topic Re: Set expression in QlikView

Set expression

upaliwije — Fri, 20 Jan 2017 03:59:17 GMT

Hi Friends

I have written a set expression in my QV doc

SUM({<BCOD={$(CMB)},(Cmb_Sector)* $>}(ACTUAL))

The above is not working. my CMB Variable is defined match(BCOD,'NU00','HL00')

Cmb_Sector is an Alternate state. Pls help me to correct the above

Re: Set expression

sushil353 — Fri, 20 Jan 2017 04:01:23 GMT

Hi,

what are you trying to do with ,(Cmb_Sector)* $

Try this:

SUM({<BCOD={'$(CMB)'}>} ACTUAL)

Re: Set expression

upaliwije — Fri, 20 Jan 2017 04:12:12 GMT

SUM({(Cmb_Sector)* $}(ACTUAL))

The above is my original set analysis with Cmb_Sector as Alternate state and It is working properly. Now I want insert a variable CMB=match(BCOD,'NU00','HL00'). Then It does not work. Even your Expression SUM({<BCOD={'$(CMB)'}>} ACTUAL) is not working.

Is there any this wrong with my variable?

Re: Set expression

Anil_Babu_Samineni — Fri, 20 Jan 2017 04:14:05 GMT

I am also not entirely sure

But, You can try similar this way and then try or Check Sushil reply and then see after that describe more if issue is still there

sum({$<BCOD= {'$(CMD)'}::[Cmb_Sector] >} ACTUAL)

Re: Set expression

sushil353 — Fri, 20 Jan 2017 04:17:12 GMT

This is because you are referencing the same two variables, which are affected by the selections in the default state.

try to calculate a another variable CMB2 = match({Cmb_Sector} BCOD,'NU00','HL00')

SUM({<BCOD={'$(CMB2)'},(Cmb_Sector)* $>} ACTUAL)

Re: Set expression

upaliwije — Fri, 20 Jan 2017 04:29:29 GMT

Thanks for the help of both of you. But none of the Expression is working. I simplified it as below. Still not working

SUM({<BCOD={"NA00"},(Cmb_Sector)* $>}(ACTUAL))

Re: Set expression

upaliwije — Fri, 20 Jan 2017 06:00:51 GMT

I am attaching herewith a sample QV document for Alternate State and kindly have a look at IT . I my pivot table there I want to show following infomation

in ALL Column total of sales as shown there and is correct

G1 Column Sales Relating to GI Depeartments

G2 Column Sales Relating to G2 Depeartments

But in Column G1 and G@ no data is shown

Pls help