topic Re: RE:Multi select in QlikView

RE:Multi select

Chanty4u — Thu, 10 Dec 2015 09:30:45 GMT

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

Re: RE:Multi select

tresB — Thu, 10 Dec 2015 09:37:02 GMT

Not quite clear. Could you explain a bit more?

Re: RE:Multi select

karthikeyan1504 — Thu, 10 Dec 2015 09:47:55 GMT

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'

Re: RE:Multi select

Anonymous — Thu, 10 Dec 2015 09:55:43 GMT

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

or for any selection?

Re: RE:Multi select

ahmar811 — Thu, 10 Dec 2015 09:59:51 GMT

try this it will help you

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:02:14 GMT

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

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:04:07 GMT

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

Re: RE:Multi select

tresB — Thu, 10 Dec 2015 10:05:45 GMT

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:07:01 GMT

i tried but its n wrkng bro....

Re: RE:Multi select

tresB — Thu, 10 Dec 2015 10:10:07 GMT

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

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:10:28 GMT

in attached qvw its nt wrkng

Re: RE:Multi select

tresB — Thu, 10 Dec 2015 10:12:33 GMT

PFA

Re: RE:Multi select

karthikeyan1504 — Thu, 10 Dec 2015 10:12:36 GMT

tresesco‌ 's method is working... please check it again

Re: RE:Multi select

Anonymous — Thu, 10 Dec 2015 10:12:44 GMT

see this..

Dont Forget, promoting the field as well

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:14:41 GMT

thanks,,, tresesco...and all..

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:15:38 GMT

Hmmm..thnx balraj......i forgot...now i got to know.

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:21:50 GMT

thnx..karthik

Re: RE:Multi select

Anonymous — Thu, 10 Dec 2015 10:23:24 GMT

NP, we r here to let you remember

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:27:09 GMT

Thnx

Re: RE:Multi select

Chanty4u — Thu, 10 Dec 2015 10:28:25 GMT

How to find exact match of a string from selection of listbox?