topic Re: Only marked Value in QlikView

Only marked Value

subbareddykm — Fri, 18 Dec 2015 10:38:06 GMT

Hi ,

I have one field Which is consist diff values,in that i want only Q1,Q2,Q3,Q4

How to get this?

Chanty4u — Fri, 18 Dec 2015 10:51:58 GMT

can u explain more?

Chanty4u — Fri, 18 Dec 2015 10:54:14 GMT

u mean default selections or always one selectd values?

subbareddykm — Fri, 18 Dec 2015 11:04:41 GMT

What i want is

if Q1-F12, Q2-F12, Q3-F12, Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;

also I want What selected in the Screenshot.

arulsettu — Fri, 18 Dec 2015 11:05:45 GMT

try this

if(Match(quarters,'Q1','Q2','Q3','Q4'),quarters) as new

subbareddykm — Fri, 18 Dec 2015 11:09:55 GMT

50% okay

Its picking only Q1,Q2 Q3 Q4;

also i want

if Q1-F12, Q2-F12, Q3-F12, Q4-F12, is there ,i want only Q1,Q2 Q3 Q4;

also I want What selected in the Screenshot.

sunny_talwar — Fri, 18 Dec 2015 11:26:46 GMT

Do you just want to filter out Q1-F12 from the list box or do you want to rename them to Q1?

If renaming, then may be this:

Pick(WildMatch(Quarter, 'Q1*', 'Q2*, 'Q3*', 'Q4*'), 'Q1', 'Q2', 'Q3', 'Q4')

Chanty4u — Fri, 18 Dec 2015 11:33:09 GMT

LOAD *, if(wildmatch(Quater, '*'&Q1&'*') or wildmatch(Quater, '*'&Q2&'*'),1,0) AS Flag

try lik dis