topic Re: Dimension in QlikView

Dimension

smilingjohn — Mon, 08 Feb 2016 09:44:29 GMT

Hi ALl

Ther is a field name called "Road" under which we have the data like

Tar road

Damber road

Cement road

Concrate road

01-pasteR

02-PasteR

03-PasteR

Paste-Rd

paste-Tr

Elevator road

Crane road

06-PasteR

Railway road

.; and so on

I am having a bar chart where iam showing the investment of by road with different condition in the expression.

Can some one tell me how to take a dimention "Road" and it should show only Paste types like o1-Paste road, 02-Paste road and so on

it should show only paste roads , How do we get this .

As of now iam taking dimension as "Road" and the expresson .

But under dimension i want to show only Paste roads of "Road"

Thanks in Advance

Re: Dimension

Anonymous — Mon, 08 Feb 2016 09:46:52 GMT

try calculated dimension

if (Match(Road,'Paste'>0, Road,null()) will test for occurence of "Paste" in Dimension Road and if so, will Show value

Re: Dimension

MK_QSL — Mon, 08 Feb 2016 09:48:54 GMT

By Calculated Dimension

Dimension

=IF(WildMatch(Upper(Road),'*PASTE*'),Road)

Tick Suppress When Value is Null

Expression

SUM(investment)

By Set Analysis

Dimension

Road

Expression

SUM({<Road = {'*PASTE*'}>}investment)

Re: Dimension

sunny_talwar — Mon, 08 Feb 2016 09:49:15 GMT

May be use a calculated dimension:

If(WildMatch(Upper(Road), '*PASTE*'), Road)

and then select 'Suppress When Value Is Null' option on the dimension tab.

Alternatively you can create a new dimension in your script:

If(WildMatch(Upper(Road), '*PASTE*'), Road) as PasteRoad

and use this in your chart which I think would be a better option then created a calculated dimension.

Re: Dimension

Chanty4u — Mon, 08 Feb 2016 09:49:36 GMT

=if({<road='o1-pasteR','02-PasteR','03-PasteR', Paste) ,null()

Re: Dimension

smilingjohn — Mon, 08 Feb 2016 09:54:56 GMT

Hi Rudolf

This expression is not working

I need to have aal those which has the paste roads , wheteher it has in beginig numbers and then paste road or after paste roads as something .

It shoul show me everything thats has paste roads .

Re: Dimension

Mon, 08 Feb 2016 09:56:23 GMT

Hi John,

You can use if(WildMatch(Road,'*paste*'),Road) in the dimension and check the suppress when value is null in dimension tab.

Re: Dimension

MayilVahanan — Mon, 08 Feb 2016 09:59:19 GMT

Try like this

Dimension

Road

Expression

SUM({<Road = {'*PASTE*'}>}investment)

Re: Dimension

Anonymous — Mon, 08 Feb 2016 10:00:43 GMT

sorry mistake from me

if (match(upper(Road), 'PASTE' > 0, Road)