QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
Champion III

RE:Multi select

hi all,

tresesco

swuehl

Marco Wedel

i have two multi box ....and one stright table

level2   and def-seviority

prj1                    critical

prj2               major

prj3               minor

lik dat i hve.... when i select  in prj1 and    critical and minor   from both the multiboxes...... i need extra colum in pivot table  as

sum of the both selcted critical and minor as well...total count of  prj1 ?

how can i achieve this?

Suresh

1 Solution

Accepted Solutions
MVP
31 Replies
MVP

Not quite clear. Could you explain a bit more?

Creator III

Hi,

your question is not clear, but I am giving the solution on my understanding of ur question... correct me if i am wrong.

In pivot table, add the expression sum({<prj1={'critical'}, prj2={'minor'}>} value)

Then enable the conditional option for the expression and write the expression as below,

Getselectedcount(prj1)=1 and getselectedcount(prj2)='minor'

Champion

on the selection of prj1, critical and minor only you want?

or for any selection?

Creator III

Champion III
Author

thnx karthikeyan..

count({<level2={'Project1','Project2','Project3','Project4','Project5'}>}Def_ID)

count({<Def_Severity={'1-critical','2-Major','3-Minor','4-Cosmetic'}>}Def_ID)

i ried this exp..its wrkng fine..

but... in pivot table the order of Def_severity not in order 1,2,3,4....it shwng 1,4,2,3

Champion III
Author

yes,...whatever the selection i need sum and total

MVP

Champion III
Author

i tried but its n wrkng bro....

MVP

I have given the screen shot from your sample qvw only.

Community Browser