Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
vengadeshpalani
Contributor

exclude selection in bar chart

IDTransportation
ACar
ABike
ABus
ACycle
AShip
BCar
BBus
BAirplane
CCar
CBus
CAirplane
CShip
DCycle
DCar
DHelicopter
DBoat

when I click B from ID list box

its related Transportation is Car,  Bus, Airplane

but business user need bar chart like

A=2 (because it have Car and Bus)

C=3 (because it have Car, Bus, Airplane)

D=1  (because it have CarBus)

Note:

I can't use Cross Table for this because it affect Data model

1 Solution

Accepted Solutions

Re: exclude selection in bar chart

May be this (using shankarece‌'s attached sample)

Count({<ID = E(ID), Transportation = P(Transportation)>}Transportation)

Capture.PNG

3 Replies
Siva_Sankar
Honored Contributor

Re: exclude selection in bar chart

Find the attached application. Do you want something like this?

Re: exclude selection in bar chart

May be this (using shankarece‌'s attached sample)

Count({<ID = E(ID), Transportation = P(Transportation)>}Transportation)

Capture.PNG

vengadeshpalani
Contributor

Re: exclude selection in bar chart

u always awesome

Thank You Sunny.......