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: 
Chanty4u
MVP
MVP

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?

thanks in advance 

Suresh

1 Solution

Accepted Solutions
31 Replies
tresesco
MVP
MVP

Not quite clear. Could you explain a bit more?

karthikeyan1504
Creator III
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'

Anonymous
Not applicable

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

or for any selection?

ahmar811
Creator III
Creator III

try this it will help you

Chanty4u
MVP
MVP
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

Chanty4u
MVP
MVP
Author

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

tresesco
MVP
MVP

Untitled.png

Chanty4u
MVP
MVP
Author

i tried but its n wrkng bro....

tresesco
MVP
MVP

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