QLIK VIEW SLICER

[AnmolGupta]

Make 2 graphs showing count of cars vs Booking Date & count of cars vs Sales Date

Make an universal global slicer which does the following:
-> filter booking trend graph
-> filter sales trend graph

I need 1 Slicer Which show number of cars book and number of car sold on that particular day

I am facing a problem where when i am selecting date say 12/22/2022 i am getting count for sales as 1 (as per the date) and my graph automatically take me to its corresponding value in boking date i just need to find the activity done on that day  but if you see on 12/22/2022 there has been NO BOOKING but 1 SALE

[MarcoWedel]

Do you have any specific questions?

What did you already try yourself to implement this requirement?

[Anonymous]

Hi Anmol, your sample data file, Book1.xlsx, has only Booking Date and Sales Date, 26 rows, with 13 unique rows. I suggest you add some sales and bookings for them, along with the expected result, with 12/22/2022 selected if you prefer. More help is appreciated.

Folks here will certainly get it done for you.

JohnInSD

(aka johncaqc)

[AnmolGupta]

i have Updated the data

Make 2 graphs showing count of cars vs Booking Date & count of cars vs Sales Date

Make an universal global slicer which does the following:
-> filter booking trend graph
-> filter sales trend graph

I need 1 Slicer Which show number of cars book and number of car sold on that particular day

I am facing a problem where when i am selecting date say 12/22/2022 i am getting count for sales as 1 (as per the date) and my graph automatically take me to its corresponding value in boking date i just need to find the activity done on that day  but if you see on 12/22/2022 there has been NO BOOKING but 1 SALE

[AnmolGupta]

Make 2 graphs showing count of cars vs Booking Date & count of cars vs Sales Date

Make an universal global slicer which does the following:
-> filter booking trend graph
-> filter sales trend graph

I need 1 Slicer Which show number of cars book and number of car sold on that particular day

I am facing a problem where when i am selecting date say 12/22/2022 i am getting count for sales as 1 (as per the date) and my graph automatically take me to its corresponding value in boking date i just need to find the activity done on that day  but if you see on 12/22/2022 there has been NO BOOKING but 1 SALE

[Anonymous]

What is your expected output when 12/22/2022 Sales Date is selected?

[AnmolGupta]

1 for the count of cars by sales date graph 

0 for the count of cars by booking date