Display custom labels in straight table

[Anonymous]

Hello Experts,

I am new to Qlikview and trying to create a straight table. Here is my requirement,

Metric	Unique Members	Unique Members	Unique Members	Unique Members
Country	India	US	UK	AUS
12/07/2014	81	21	19	6
12/08/2014	164	46	41	18
12/09/2014	207	57	48	17
12/10/2014	166	42	37	20
12/11/2014	174	44	39	18
12/12/2014	156	43	36	18
12/13/2014	89	26	24	8
12/14/2014	82	24	20	9

I want to display country names in second row instead of totals of unique visitors and also I am calculating this unique visitors based on country column

Can anyone help me how to achieve this custom country names

Regards,

Kumar

[PrashantSangle]

Hi,

Can you provide sample data??

If you have country Name in your table then add it as dimension.

Use Pivot table instead of Straight Table and drag Country Name dimension from vertical to horizontal.

Regards

[anbu1984]

Replace your Unique visitors count for India by this expr

=If(Dimensionality() <>0, India_Unique_Cnt_Expr,'India')

[Anonymous]

I have almost all 400 countries are there, but in my requirement I want to display only for 4 countries that too without having any list box, static box etc. I am using source as QVD files.

Regards,

Kumar

[PrashantSangle]

Hi,

Then use calculated Dimension.

Try like

if(wildmatch(Country,'USA','UK'),Country)

Regards

[#6]

Hey Kumar,

Try crosstable while loading the data...

You can refer attached QVW.

Regards,

Nitesh

[hariprasadqv]

In a stright table it may not be possible directly. But you can do it in the pivot table easily by drag and drop of fields arranagement.

[#8]

hI @KUMAR REDDY

You can try in this .You can Swap your table order in the Pivot Table only.

Check this images

1)Normal

2) You Swap Your Dimension While Click on the dimension drag it on the place you want

3)After You can see the Month column has dragged in the images.

This Can Be Done Only In Pivot Table Only.You can try it in the Pivot Table also

[#9]

Hi,

You can write in Dimension tab below this expression.

=If(Match(Country,'India','US','UK','AUS'),Country)