topic Dimention restriction in QlikView

Dimention restriction

Fri, 30 Jan 2015 01:03:58 GMT

Within a selected Dimention, How do I restrict the value to only show a selected items.

Colour	Name	country
Red	AAA	USA
Blue	BBB	USA
Yellow	CCC	UK
Blue	DDD	USA

Above example, I want to count total number of people in Country USA where Colour = Red or Blue

Thank you in advance.

Re: Dimention restriction

sujeetsingh — Fri, 30 Jan 2015 01:16:38 GMT

Use set analysis or if condition in the count expression

Count({<Colour={'Red'},Colour={'Blue'} Name)

count(if(Colour='Red' or Colour='Blue',Name))

Re: Dimention restriction

sujeetsingh — Fri, 30 Jan 2015 01:17:35 GMT

May be you can use wild-match in if statement and need to refine the one for set-analysis for correct syntax.

Re: Dimention restriction

Fri, 30 Jan 2015 01:32:56 GMT

Hi Sujeetsingh,

I've tried it, the result came back to only show the last value, in this case, only show where colour = Blue. not able to get both Red and Blue colour result. Help please.

Re: Dimention restriction

Fri, 30 Jan 2015 02:51:57 GMT

just have a text box with this expression

=Count({1<Colour={'Red','Blue'}>} Name)

Re: Dimention restriction

PrashantSangle — Fri, 30 Jan 2015 03:57:09 GMT

Hi,

Try

Count({<Colour={"Red","Blue"}>}Name)

If you want to restrict dimension then

Create Straight table

add dimension as Calculated dimension

write

if(wildmatch(Colour,'Red','Blue'),Colour)

and check supress null Value in dimension tab

In expression tab

Write

Count(Name)

or if you required distinct count then try with distinct

Count(Distinct Name)

Regards

Re: Dimention restriction

sagarkharpude — Fri, 30 Jan 2015 04:01:21 GMT

=Count({<Colour={'Red','Blue'},Country={'USA'}>}distinct Name)

Re: Dimention restriction

Fri, 30 Jan 2015 04:23:04 GMT

Hi Ramkumar,

What is the 1 in the formula for?

What is a text box?

Re: Dimention restriction

PrashantSangle — Fri, 30 Jan 2015 04:28:14 GMT

Hi,

1. It represents the full set of all the records in the application.

and The $ sign represents the records of the current selection.

For more details go to help menu of qlikview App types Set Analysis.

You will get more information.

Regards

Re: Dimention restriction

sujeetsingh — Fri, 30 Jan 2015 04:36:12 GMT

Lily can you post a sample.

Re: Dimention restriction

sujeetsingh — Fri, 30 Jan 2015 04:54:47 GMT

See this sample

Re: Dimention restriction

Fri, 30 Jan 2015 05:20:33 GMT

Hi Lily,

May be Like this?

PFA.

Thanks,

Chiru