topic Re: Bring dimension values whether it has data or not in QlikView

Bring dimension values whether it has data or not

keerthika — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can any one say, how to bring all customers whether they contain data or not for all yearperiod and monthperiod

Thanks,

keke

Re: Bring dimension values whether it has data or not

rajivmeher — Thu, 20 Sep 2018 08:38:45 GMT

Hi Keerthika

Just want a bit more clarity on this, are you trying to bring data into Qlikview from a different source or you have data in Qlikview, however you want to show the data in a table or listbox?

If its from source than Concatenation may help, if its to a QV object, than checking supress null value may help.

If possible please share sample data or sample QVW, so that we can suggest further?

Regards

Rajiv.

Re: Bring dimension values whether it has data or not

prieper — Thu, 20 Sep 2018 08:53:14 GMT

in StraightTable go to Properties -> Presentation -> Untick " Suppress Zero-Values" and "Suppress Missing"

HTH Peter

Re: Bring dimension values whether it has data or not

keerthika — Thu, 20 Sep 2018 10:00:54 GMT

Hi,

Here my issue is i'm having 2 category from 2 different table iam concatenating both to show in one table . one category for one metric and another for another metric but both category is from customer table, based on metric selection i need to show customers under the category.

For example :

I'm having 2 metric -> 1sale and 2sale

selection : Month - jan, feb Year - 2018,2017

When i select jan 2018 and both metric my result is

customer	category1 sales	category2 sales
1	20	67
2	30	45
3	60	65

when i select jan 2017 and 2sale metric my result is

customer	category2 sales
1	67
2	43

My expected result is

customer	category2 sales
1	67
2	45
3	0

Under category 2 I didn't have data for customer 3 but still i need to show that customer , here i can't able to unselect the 'suppress zero' because if i do that i will get all the customer present in category1 but i need only the customer from category2 where they have a data or not.

Re: Bring dimension values whether it has data or not

raman_rastogi — Thu, 20 Sep 2018 10:19:28 GMT

Add + SUM({1}0) In your expression.

ex-

Sum(Fact) + SUM({1}0)

It will show all values of dimension whether it has value or not.

Thanks

Raman Rastogi

Re: Bring dimension values whether it has data or not

rajivmeher — Thu, 20 Sep 2018 10:23:24 GMT

Thanks for the detail.

Please goto the table properties, goto presentation tab. Select the dimension and select Supress Zero-Values.

If that doesn't work, I would suggest to share sample QVW, so that we can have a look at the issue.

Regards

Rajiv.

Re: Bring dimension values whether it has data or not

keerthika — Thu, 20 Sep 2018 10:39:04 GMT

Hi,

If i unselect suppress Zero , customers from the category1 is also show, but i need only all customers from category2 when i select only the metric as -> 2sale

Re: Bring dimension values whether it has data or not

keerthika — Thu, 20 Sep 2018 11:03:46 GMT

Hi Raman,

It's not working

Re: Bring dimension values whether it has data or not

keerthika — Thu, 20 Sep 2018 11:16:04 GMT

Hi Rajiv,

Can you pls share sample QVW

Re: Bring dimension values whether it has data or not

raman_rastogi — Thu, 20 Sep 2018 11:37:20 GMT

Unchecked suppress zero values from presentation tab

check attached file.

Regards

Raman Rastogi

Re: Bring dimension values whether it has data or not

keerthika — Thu, 20 Sep 2018 11:48:12 GMT

Hi Raman,

In your QVW script , don't use Category2sale in first load script. In this case how you solve it