Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Using variables in Set analysis

Hi All,

I'm trying to use an aggregated variable in set analysis with dimension in set analysis:

vVariable1 = (Sum({<[Yesterday] -= {'-'}>}qc_overpick_lines))

vVariable2 =  (Sum({<[Yesterday] -= {'-'}>}qc_mispick_lines))

vVariable3 = (Sum({<[Yesterday] -= {'-'}>}qc_underpick_lines))

In the set analysis, i'm trying to use these variables:

=(Only({<SHIFTNAME= {'A'}>}vVariable1 +vVariable2+vVariable3))

All i'm doing above statement is, using Shift dimension.

But this is not working..

Any help is highly appreciated!

1 Solution

Accepted Solutions
Not applicable

Hi Mark, I think you should be using a dollar expansion here. e.g.

     $(vVariable1) + $(vVariable2)+ $(vVariable3).

However it won't work anyway because nested aggregation is not allowed here. Insread can you try this?

=Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_overpick_lines)

  +

Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_mispick_lines)

+

Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_underpick_lines)

You can store each of those expressions in variables and say

=$(v1)+$(v2)+$(v3)

Thanks,

Ram

View solution in original post

6 Replies
Not applicable

Hi Mark, I think you should be using a dollar expansion here. e.g.

     $(vVariable1) + $(vVariable2)+ $(vVariable3).

However it won't work anyway because nested aggregation is not allowed here. Insread can you try this?

=Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_overpick_lines)

  +

Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_mispick_lines)

+

Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_underpick_lines)

You can store each of those expressions in variables and say

=$(v1)+$(v2)+$(v3)

Thanks,

Ram

markgraham123
Specialist
Specialist
Author

Ram,

But I have to create too many variables to get to my final layout.

Can we create a single variable which would give us all totals for shift

name A instead of 3 diff. Variables....?

On Tuesday, July 19, 2016, Ramkumar Ramagopalan <qcwebmaster@qlikview.com>

Not applicable

Yes Mark. You can put that entire expression into a variable.

Say vShiftNameACalc

=Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_overpick_lines+ qc_mispick_lines + qc_underpick_lines)

markgraham123
Specialist
Specialist
Author

This did not work Ram!

=Sum(({<SHIFTNAME= {'A'}, ({<[Yesterday] -= {'-'}>} qc_overpick_lines+ qc_mispick_lines + qc_underpick_lines)



This worked

=(Sum({<SHIFTNAME= {'A'},[Yesterday] -= {'-'}>}qc_overpick_lines))

+

(Sum({<SHIFTNAME= {'A'},[Yesterday] -= {'-'}>}qc_mispick_lines))

+

(Sum({<SHIFTNAME= {'A'},[Yesterday] -= {'-'}>}qc_underpick_lines))

Not applicable

I see 2 brackets after Sum. Please remove one.

Sent from my iPhone

markgraham123
Specialist
Specialist
Author

Thanks a lot Ram!