topic Display custom labels in straight table in QlikView

Display custom labels in straight table

Anonymous — Wed, 18 Mar 2015 07:48:01 GMT

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

Re: Display custom labels in straight table

PrashantSangle — Wed, 18 Mar 2015 08:03:41 GMT

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

Re: Display custom labels in straight table

anbu1984 — Wed, 18 Mar 2015 08:06:13 GMT

Replace your Unique visitors count for India by this expr

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

Re: Display custom labels in straight table

Anonymous — Wed, 18 Mar 2015 08:10:35 GMT

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

Re: Display custom labels in straight table

PrashantSangle — Wed, 18 Mar 2015 08:16:35 GMT

Hi,

Then use calculated Dimension.

Try like

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

Regards

Re: Display custom labels in straight table

Wed, 18 Mar 2015 08:21:17 GMT

Hey Kumar,

Try crosstable while loading the data...

You can refer attached QVW.

Regards,

Nitesh

Re: Display custom labels in straight table

hariprasadqv — Wed, 18 Mar 2015 09:12:52 GMT

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.

Re: Display custom labels in straight table

Wed, 18 Mar 2015 09:41:40 GMT

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

Re: Display custom labels in straight table

Wed, 18 Mar 2015 10:20:36 GMT

Hi,

You can write in Dimension tab below this expression.

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