topic Re: Qlik Sense Dimension Limitation issue in App Development

Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 12:32:53 GMT

Hello,

I am struggling with getting the proper data to display within my bar chart. I want to display the bottom 10 product lines we have by revenue. When I add a limitation to the Dimension (Product Line), I cant seem to have it display the bottom 10. We have several product lines that come in at 0 at the present time due to data not being filled in.

So, when I limit by fixed number & bottom 10, I only get the 0's to display. When I then uncheck display zero values in the add on, data handling area, I get an error that says "The selections generated no data for this chart".

Please help me with this one - we have been trying to fix this for quite some time.

Thank you so much for your time.

My best,

Russ

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 12:37:06 GMT

Would you be able to supply some dummy raw data with the output you are looking to get?

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 12:41:59 GMT

At this time, I do not think so...we are still trying to solve this without sampling.

Dimension is just:

[Product Line]

Revenue measure is:

sum(if(Year>2016 and [Financial View]='Budgeted',[Revenue (dollars)],if(Year<2017 and [Financial View]='Actual',[Revenue (dollars)],0)))

I attempted the formula you suggested last week, and I could not get it to change anything on the display when I replaced the measure expression.

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 12:44:10 GMT

On a fixed number limitation with the bottom field selected,

In the expression field:

13 + Count({<[Revenue (dollars)]-={'0'}>}[Product Line])

worked on a general display.

When we filtered by business segment or anything though, this did not continue to work.

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 12:44:39 GMT

At this time, I do not think so...we are still trying to solve this without sampling.

For somebody who is trying to solve this for quite some time, I would have thought would have learned there lesson that some problems are difficult to address without having to take a look at a sample....

But if you still want to try a little more... I am good with that, I will wait for the time when you think it is appropriate to share a sample.

Also, look here

How to get answers to your post?

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 12:51:31 GMT

Thanks Sunny,

I am exploring options before venturing down the sample route. This issue does not seem to be difficult to explain without supplying sample data, is there something you are not understanding from my issue posts?

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 12:55:18 GMT

Do you know the steps for supplying sample data in case that is an option we decide to take?

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 12:55:21 GMT

I understand the issue, but I just don't know how your data looks like, how are you connecting different fields and what are you getting more selection in business segment and what you are hoping to see after selection

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 12:56:22 GMT

For attaching something here

Uploading a Sample‌

If you need a place which can help you generate some mock-up data

Mockaroo - Random Data Generator | CSV / JSON / SQL / Excel

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 13:04:57 GMT

ahhh ok,

I will explain here and lets see if we can shed some light.

So, I have a bar chart that with no limitation shows about 100 product lines total. about 20 of them have data filled in and are displaying, numbers like 2,300, 3,400 etc...

Now these product lines are categorized under product units (and there is about 10 of these that all the different product lines belong to), then those product units are categorized under main business segments. (there are 4 main business segments)

The data is setup in the table by revenue (measure) and product line (dimension).

What we want to see is the bottom 10 product lines no matter what filter is applied. Right? So, if I sort by overall business segment, I would like to see bottom 10 product lines by revenue across all product units. if I sort by an individual product unit, bottom 10 or as many as there for that product unit.

We have filters for business segment, product unit, and year (I don't think this applies)

Let me know your thoughts...

Thanks,

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 13:13:44 GMT

What we want to see is the bottom 10 product lines no matter what filter is applied. Right? So, if I sort by overall business segment, I would like to see bottom 10 product lines by revenue across all product units.

So when a business segment is selected, you want to see the bottom 10 product lines within that business segment only?

This is the expression you are using today?

13 + Count({<[Revenue (dollars)]-={'0'}>}[Product Line])

What is the significance of 13 here?....

You issue is that once you select a business segment, everything goes away? But the above expression shouldn't do that... I mean I don't see a reason why it would give you problems when you select business segment.

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 13:19:58 GMT

So when a business segment is selected, you want to see the bottom 10 product lines within that business segment only?

-Yes, even if there are less than 10 product lines, we want to see the bottom x number

This is the expression you are using today?

13 + Count({<[Revenue (dollars)]-={'0'}>}[Product Line])

-Yes, the 13 is not significant - we just used a number until 10 displayed. for some reason we had to type 13 to display 10 on the bar chart....working on it this morning - typing 1 + .... now shows the 10 product lines

What is the significance of 13 here?....

There is no significance -> it just worked on the non-filtered view and showed to bottom 10 when we do not display zero values....

Yes, once we select a business segment, nothing is displayed and we get the "The selections generated no data for this chart," even though we know there is data behind there

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 13:23:20 GMT

may we share a sample with you and not post to forum?

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 13:24:42 GMT

I have requested to follow you, once you allow me to follow you, you should be able to send me message. I can share my email over the private message....

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 13:28:25 GMT

Does my reply help with what we are looking to go after?

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 13:29:30 GMT

You did answer all the things, but its difficult to point out what might be going wrong...again things become easier when you see the issue...

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 13:31:06 GMT

ok do you have any further thoughts on expressions or limitation we can try?

Re: Qlik Sense Dimension Limitation issue

sunny_talwar — Mon, 21 Aug 2017 13:31:48 GMT

Unfortunately, I don't

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 14:52:17 GMT

Ok so if we could write an expression in the measure to limit it to only display results that are great than 0, we could just set the dimension limitation to bottom -> 10 and this should work.

Can you write me an expression that limits the measure to only 10 results?

Re: Qlik Sense Dimension Limitation issue

Anonymous — Mon, 21 Aug 2017 16:20:13 GMT

I got it! with a dimension expression.

Thank you so much Sunny!