Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Chanty4u
Champion III
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?

thanks in advance 

Suresh

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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'

balrajahlawat
Champion
Champion

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
Champion 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

Chanty4u
Champion III
Champion III
Author

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

tresesco
MVP
MVP

Untitled.png

Chanty4u
Champion III
Champion III
Author

i tried but its n wrkng bro....

tresesco
MVP
MVP

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