topic Re: straight table dimension issue. in QlikView

straight table dimension issue.

vinay_hg — Thu, 11 Dec 2014 11:35:04 GMT

Guys,

i have 2 tables, between 2 tables userid is key, imagine for a date period

one user table

userid geo username

1 India raj

2 KSA gagan

3 UK meera

4 USA neel

sales activity table

activityid userid desc

1 1 YYYYY

2 3 CCCC

3 3 UUUU

4 3 UUURRR

I WANT RESULT like below

Username total activities

raj 1

gagan 0

meera 3

neel 0

but am getiing

Username total activities

raj 1

meera 3

pls help

i had used Username in dimension and activity count on exp.

and

note:

when am sending report based on GEO wise for india.

according to above 1 user should come if there are 2 users from india 2 users should come. if i check show all value

users from all geo will come. because this report is geo wise pdf report.3 report idf 3 geos. all users from that geo should come irrespective of activities created. geo is been hardcoded in expression as it is pdf requirement.

Re: straight table dimension issue.

alexandros17 — Thu, 11 Dec 2014 11:37:35 GMT

Check the box show all values in dimension and n presentation uncheck "suppress zero values" and "suppress missing"

let me know

Re: straight table dimension issue.

vinay_hg — Thu, 11 Dec 2014 11:45:26 GMT

sorry my question was not full..

when am sending report based on GEO wise for india.

according to above 1 user should come if there are 2 users from india 2 users should come. if i check show all value

Re: straight table dimension issue.

syukyo_zhu — Thu, 11 Dec 2014 11:50:59 GMT

you can juste desactivate "supress zero value"

Re: straight table dimension issue.

amit_saini — Thu, 11 Dec 2014 12:07:26 GMT

Vinay,

Like this/???

Thanks,
AS

Re: straight table dimension issue.

vinay_hg — Thu, 11 Dec 2014 12:23:20 GMT

yesbut for 1 geo

Re: straight table dimension issue.

amit_saini — Fri, 12 Dec 2014 04:27:08 GMT

Check this.

Thanks,
AS