topic Re: Total in Straight table row wise in QlikView

Total in Straight table row wise

Mon, 24 Mar 2014 10:10:41 GMT

Hi,

I have a straight table where i want to show Row wise Total.

In Dim i have few strings like

Dim Expr(Count)

Product1 Source 55

Product2 Source 150

Product Target 10

Product1 Target 25

Product2 Target 25

Product3 Source 30

What i want is Just two fields in Dim and Expr as

Dim Total

Source 235

Target 60

I used set analysis though but not getting what i expect..

Thanks.

Re: Total in Straight table row wise

Mon, 24 Mar 2014 10:19:36 GMT

hi gtripathy,

can u please explain your Question more briefly So can Help u Quickly

Re: Total in Straight table row wise

alexandros17 — Mon, 24 Mar 2014 10:20:28 GMT

here is an example

Re: Total in Straight table row wise

arsal_90 — Mon, 24 Mar 2014 10:24:42 GMT

Can u just provide the sample data then i will make a sample document for u

Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 10:29:02 GMT

Hi,

Create Straight Table ,

Use Dimension as,

=if(WildMatch(Dim,'*Target'),'Target','Source')

And Expression as Sum(Count)

For Better understanding I am attaching application.

Regards,

Re: Total in Straight table row wise

sunilkumarqv — Mon, 24 Mar 2014 10:37:30 GMT

Use below Expression as your calculated dimension instead of Dim (Original)then label it as Dim

=If(index(Dim,'Source'), 'Source', 'Target')

Re: Total in Straight table row wise

Mon, 24 Mar 2014 10:52:44 GMT

Hi All,

Sorry if i couln't explain the req properly.

I'm showing counts of Source and Target for Product1,Product2...etc like below

Product1 Source 55

Product2 Source 150

Product Target 10

Product1 Target 25

Product2 Target 25

Product3 Source 30

What i want is Just to display Source and Target (Where Source ll show the Total of Product1 Source,Product2 Source.. i,e all Product source) and likewise Target ll show Total of all Target Products.

Re: Total in Straight table row wise

Anonymous — Mon, 24 Mar 2014 11:02:07 GMT

well in your case solution given by max dreamer should work have you tried ?

anant

Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 11:02:28 GMT

Hi,

Can you provide sample data with proper dim data so that we can work on it

Regards

Re: Total in Straight table row wise

Mon, 24 Mar 2014 11:16:25 GMT

=if(WildMatch([product Name],'*Source*'),'Source', if(WildMatch([product Name],'*Target*'),'Target'))

I'm using this expression but don't know why don't i see Target??

Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 11:20:31 GMT

Hi,

Use my expression given above

Try this

=if(WildMatch([product Name],'*Source'),'Source','Target')

Regards,

Re: Total in Straight table row wise

Mon, 24 Mar 2014 11:23:11 GMT

I have three category actually.(Source,Target,Excl) but i want to show only for Source and Target

Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 11:27:12 GMT

Hi,

Then try this

=if(WildMatch([product Name],'*Source'),'Source',if(WildMatch([product Name],'*Target'),'Target'))

Regards,

Re: Total in Straight table row wise

Mon, 24 Mar 2014 11:32:20 GMT

Nope max Dreamer.It's not correct.throwing error.If i use Nested If it's working fine but only showing Source and Total for all Product Source.can't see Target

Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 11:33:30 GMT

Hi,

my bad I had just update my expression,

Regards,

Re: Total in Straight table row wise

Mon, 24 Mar 2014 11:45:55 GMT

That's the one i posted above too.It's showing though but count is not correct again.Source total is correct but Target total is taking instead Excl totals.

Re: Re: Total in Straight table row wise

PrashantSangle — Mon, 24 Mar 2014 11:55:27 GMT

Hi,

Where you are getting wrong total??

In My attached app it works fine.

I am attaching my app check it.

It might help you.

Regards