Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a straight table where i want to show Row wise Total.
In Dim i have few strings like
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
I used set analysis though but not getting what i expect..
can u please explain your Question more briefly So can Help u Quickly
here is an example
Can u just provide the sample data then i will make a sample document for u
Create Straight Table ,
Use Dimension as,
And Expression as Sum(Count)
For Better understanding I am attaching application.
Use below Expression as your calculated dimension instead of Dim (Original)then label it as Dim
=If(index(Dim,'Source'), 'Source', 'Target')
Sorry if i couln't explain the req properly.
I'm showing counts of Source and Target for Product1,Product2...etc like below
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.
well in your case solution given by max dreamer should work have you tried ?
Can you provide sample data with proper dim data so that we can work on it
=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??