topic Dimension field filter in straight table or pivot table and display total in QlikView

Dimension field filter in straight table or pivot table and display total

Anuhyak1 — Sat, 07 Mar 2020 15:29:53 GMT

I have Org divison and store type are the dimensions in my Straight/Pivot table. I have Store type with Direct,Full Line, outlet ,undefined,Miltary values in Current selection box. I want to display only Direct and Full Line for store type and their Totals. I have to display the Lastweek,Last year,%change values in the expression for Direct and Full Line. How to display pivot table or straight table please suggest.

Re: Dimension field filter in straight table or pivot table and display total

Brett_Bleess — Thu, 02 Apr 2020 15:32:41 GMT

My best advice would be to use the Design Blog area of Community to search the how-to posts there to see if you can find something to give you the proper idea as to how to go about things. If you get things further along and can then post an app sample etc., you may be able to get some further help at that point, but believe things are a bit too thin at the moment for anyone to really offer much help. Generally it requires at least some sample data and what you expect the output to look like in order for someone to be able to help much in these situations. In this case sample QVW with the data model and chart etc. would likely be best case in order to get further help with things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Dimension field filter in straight table or pivot table and display total

sunny_talwar — Thu, 02 Apr 2020 15:41:16 GMT

You can use set analysis to restrict your expression to only show Store Types Direct and Full Line... For example, if you expression was Sum(Sales), you can change it to Sum({<[Store Type] = {'Direct', 'Full Line'}>} Sales)

Re: Dimension field filter in straight table or pivot table and display total

Brett_Bleess — Thu, 02 Apr 2020 17:24:47 GMT

Given Sunny's direction, you can check out this specific Design Blog post, might be helpful given his advice:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett